[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