ltbaggz Posted January 7, 2007 Share Posted January 7, 2007 I am trying to write a simple search query to select users by last name. I dont want to have to type the name exactly to get results, ideally being able to type 3 or so of the last name and display a list of matching ones. Ive tried some different combinations of % signs and LIKE but nothing seems to be doing the trick, so if anyone has a quick answer i would appreciate it.Drew Link to comment https://forums.phpfreaks.com/topic/33227-simple-search-query-question/ Share on other sites More sharing options...
andrew_ww Posted January 7, 2007 Share Posted January 7, 2007 Try LIKE \"%$variable%\"Regards,Andy. Link to comment https://forums.phpfreaks.com/topic/33227-simple-search-query-question/#findComment-155112 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.