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 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 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
Archived
This topic is now archived and is closed to further replies.