[nycphp-talk] MYSQL SELECT Error Question
jim at bizcomputinginc.com
Thu Feb 27 21:51:07 EST 2003
You need to delimite Service since it is a constant and not a data column.
ie. mysql> select * from Members where Business_Type = 'Service';
Jim Hendricks, President, Biz Computing, Inc
Phone: (201) 599-9380 Email: jim at bizcomputinginc.com
Snail: Jim Hendricks, Biz Computing, Inc., 255 McKinley Ave, New Milford,
----- Original Message -----
From: "Steve Soler" <steve at soler.com>
To: "NYPHP Talk" <talk at nyphp.org>
Sent: Thursday, February 27, 2003 9:47 PM
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