Canman2005 Posted October 29, 2009 Share Posted October 29, 2009 Hi all I am building a simple search to look in multiple fields in my database based on a phrase. Is it possible to write a query that would take a phrase such as "Adobe Software" and check both "Adobe Software" "Adobe" "Software" So it would basically split the phrase submitted and lookup each word in that phrase using a LIKE %% Any help would be great Thanks Ed Link to comment https://forums.phpfreaks.com/topic/179427-solved-split-and-query-phrase/ Share on other sites More sharing options...
Alex Posted October 29, 2009 Share Posted October 29, 2009 So basically you're wanting to put in a phrase like 'Adobe Software' and get back LIKE '%Adobe%' OR LIKE '%Software%'? You can use: function like_format($str) { return implode(' OR ', array_map(create_function('$a', 'return "LIKE \'%$a%\'";'), explode(' ', $str))); } Link to comment https://forums.phpfreaks.com/topic/179427-solved-split-and-query-phrase/#findComment-946708 Share on other sites More sharing options...
Canman2005 Posted October 29, 2009 Author Share Posted October 29, 2009 Nice, thanks dude Link to comment https://forums.phpfreaks.com/topic/179427-solved-split-and-query-phrase/#findComment-946713 Share on other sites More sharing options...
Canman2005 Posted October 29, 2009 Author Share Posted October 29, 2009 If I do SELECT * FROM `products` WHERE `name` LIKE '%adobe%' OR LIKE '%products%' I get a You have an error in your SQL syntax; any ideas? Link to comment https://forums.phpfreaks.com/topic/179427-solved-split-and-query-phrase/#findComment-946718 Share on other sites More sharing options...
Canman2005 Posted October 29, 2009 Author Share Posted October 29, 2009 figured it, thanks for inital help Link to comment https://forums.phpfreaks.com/topic/179427-solved-split-and-query-phrase/#findComment-946733 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.