I think you need to put '' around joe 'joe' Stuart --- 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. ??? > > -- > 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
