Select where
| From: | boclair | Date: | Tue, 20 Mar 2001 14:02:04 +0000 |
| Subject: | Select where | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7640@lists.php.net to get a copy of this message | ||
This is simple but I cannot see where I am going wrong
I have a table members with one of the fields
status, varchar(10)
The values may be active or retired or deceased or null
If I run the select
SELECT * FROM members WHERE status = 'deceased';
I get MySQL said: You have an error in your SQL syntax near
'\'deceased\';' at line 1
Will somebody show me the correct syntax
Tim Morris