select first_name, lastname from user where first_name like '%$user%' or last_name like '%$user%' ;
--- Matt Babineau <[EMAIL PROTECTED]> wrote: > Hey All- > > Got a fun question - I hit the manual but not much > luck on my question. I > want to combine 2 fields and then search them.... > > SELECT first_name, lastname FROM user WHERE > CONCAT(first_name, ' ', > last_name) LIKE '%$user%' > > Does this make sense? The CONCAT function was the > closest I found to try and > do what I want to do. I alread tried this: > > SELECT concat(first_name, ' ', last_name) as > fullname FROM user... > > This did not work. If anyone has any ideas on how to > search for users when > the first_name and last_name fields are broken up > I'm all ears! > > > Thanks, > > Matt Babineau > Criticalcode > 858.733.0160 > [EMAIL PROTECTED] > http://www.criticalcode.com > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Make Yahoo! your home page http://www.yahoo.com/r/hs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
