> --- Pete Holsberg <pjh@xxxxxxxx> wrote: > > > On Mon, 6 Sep 2004 > > php-list-replies@xxxxxxxxxxxxxxxxxxxxx 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. ??? On Mon, 6 Sep 2004, Stuart Felenstein wrote: > I think you need to put '' around joe 'joe' > > Stuart Tried that. It said that 'Joe' was an unknown column! Besides, Joe is the value of a variable passed by another script. Thanks. > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
