NYCPHP Meetup

[nycphp-talk] MYSQL SELECT Error Question

Christopher Hendry chendry at nyc.rr.com
Thu Feb 27 21:52:13 EST 2003


try:

select * from Members where Business_Type = 'Service';

Probably the quotes around 'Service'.

-> -----Original Message-----
-> From: Steve Soler [mailto:steve at soler.com]
-> Sent: Thursday, February 27, 2003 9:48 PM
-> To: NYPHP Talk
-> Subject: [nycphp-talk] MYSQL SELECT Error Question
-> 
-> 
-> Can anyone help me decipher this error I'm getting in MYSQL?
-> I'm certain there are rows in my database that contain the word 
-> "Service" in the "Business_Type" column.
-> 
-> Below is the Select command and the error I'm getting. It's copied 
-> right of my Telnet program.
-> 
-> mysql> select * from Members where Business_Type = Service;
-> ERROR 2000: Unknown column 'Service' in 'where clause'
-> 
-> 
-> Thanks in advance,
-> - Steve
-> 
-> 
-> 
-> --- Unsubscribe at http://nyphp.org/list/ ---
-> 
-> 
-> 




More information about the talk mailing list