Jump to content

[SOLVED] Split and Query Phrase


Canman2005

Recommended Posts

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

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)));
}

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.