Hi I have 1 table in my project, called "sf_guard_user_profile". In which, there are 2 fields,
1. first_name 2. last_name I m working on search module in table, suppose there is 1 entry firstname = 'John' lastname = 'Lee' In search if any body searches for 'john lee', how to match ? bcoz query should be like.. first_name+' '+last_name = 'john lee' If user searches for "john" or "lee" than I can display records, $k->getNewCriterion(sfGuardUserProfilePeer::FIRST_NAME,"%".$this- >query."%",Criteria::LIKE) $k->getNewCriterion(sfGuardUserProfilePeer::LAST_NAME,"%".$this- >query."%",Criteria::LIKE) but I dont know how to write for 'first_name' + ' ' + 'last_name' Pls help me... Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---