c_shelswell Posted November 30, 2009 Share Posted November 30, 2009 Hi I've been looking about for this but can't seem to find an answer. I have a string that I need to search in the database for eg 'Fruitshop opens 7am' but my database field only says 'Fruitshop' I thought I could just use a search like: select * from table where field like %Fruitshop opens 7am% but that won't seem to find Fruitshop. Any ideas? Cheers Quote Link to comment https://forums.phpfreaks.com/topic/183476-search-part-for-part-of-a-string-in-a-field/ Share on other sites More sharing options...
c_shelswell Posted November 30, 2009 Author Share Posted November 30, 2009 found the solution! All i needed to do was use a fulltext search maybe this will help someone else: select * from table where match (field) against ('Fruitshop opens 7am') cheers Quote Link to comment https://forums.phpfreaks.com/topic/183476-search-part-for-part-of-a-string-in-a-field/#findComment-968509 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.