[SOLVED] Split and Query Phrase

[Canman2005]

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

[Alex]

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

[Canman2005]

Nice, thanks dude

[Canman2005]

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?

[Canman2005]

figured it, thanks for inital help