NYCPHP Meetup

[nycphp-talk] MYSQL SELECT Error Question

Melissa melissa at inexact.info
Thu Feb 27 21:52:50 EST 2003


do you have quotes around the word 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