I have a database with a first and last name fields that I would like to combine for a search. Basically on my web page interface I would like the end user to fill out one field instead of individual first and last fields. I tried writing a query like so;
SELECT id, CONCAT(first," ",last) AS name FROM ceem_founder WHERE status='live' AND name LIKE '%Sam Spade%' I get an error that the "name" field does not exist. Any help appreciated. Thanks, Tom --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
