thehigherentity Posted June 7, 2007 Share Posted June 7, 2007 Is there any way I can return results by searching part words ? eg I have a table with 5 columns Id | Name | address | Phone | email Lets say I have 3 people in this table with the following names Smith, Stephen Michael Wilson, Sarah Louise Wood, Stephanie Anne What I want to be-able to do is search part of the name eg "steph" and get the results that contain this. which from this example would be Smith, Stephen Michael Wood, Stephanie Anne At the moment I am returning all the results and looping through them doing a php check but I now have over 2000 people and growing fast. any help that can be given would be appreciated Quote Link to comment https://forums.phpfreaks.com/topic/54549-solved-return-data-from-part-word-search/ Share on other sites More sharing options...
bubblegum.anarchy Posted June 7, 2007 Share Posted June 7, 2007 SELECT * FROM repository WHERE name LIKE '%steph%' % = wildcard http://dev.mysql.com/doc/refman/4.1/en/string-comparison-functions.html Quote Link to comment https://forums.phpfreaks.com/topic/54549-solved-return-data-from-part-word-search/#findComment-269808 Share on other sites More sharing options...
thehigherentity Posted June 7, 2007 Author Share Posted June 7, 2007 Thanks for that, I did look at that earlyer but wasnt too sure it would do what i wanted but it seems to work Quote Link to comment https://forums.phpfreaks.com/topic/54549-solved-return-data-from-part-word-search/#findComment-269811 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.