NYCPHP Meetup

[nycphp-talk] MYSQL SELECT Error Question

Jim Hendricks 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
______________________________________________________________
Jim Hendricks, President, Biz Computing, Inc
Phone:  (201) 599-9380     Email: jim at bizcomputinginc.com
Web: www.bizcomputinginc.com
Snail:  Jim Hendricks,  Biz Computing, Inc.,  255 McKinley Ave, New Milford,
NJ 07646
______________________________________________________________


----- 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 mailing list