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

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to