Re: Another newbie question
| From: | Stuart Felenstein | Date: | Mon, 06 Sep 2004 22:28:35 +0000 |
| Subject: | Re: Another newbie question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36077@lists.php.net to get a copy of this message | ||
I think you need to put '' around joe 'joe'
Stuart
--- Pete Holsberg <pjh@mccc.edu> wrote:
> On Mon, 6 Sep 2004
> php-list-replies@listmail.innovate.net wrote:
>
> > you should copy/paste that into a command-line
> msyql
> > session and see if that works.
>
>
> I cut the query back to
>
> SELECT * FROM Directory WHERE
LastName LIKE Joe
> ORDER BY Street, HouseNum, LastName
>
> and ran it manually. I got
>
> ---
> SQL-query :
>
> SELECT *
> FROM Directory
> WHERE LastName
> LIKE Joe
> ORDER BY Street, HouseNum, LastName
> LIMIT 0 , 30
>
> MySQL said:
>
> Unknown column 'Joe' in 'where clause'
> --------
>
> Perhaps I don't understand LIKE. LastName is a
> column; Joe
> is a value. ???
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>