MySQL Search on TEXT field: words in any order
Posted: Wed Mar 10, 2010 3:50 am
Hello
I am sure I have posted this before but cannot find my post.
If a field contains "target gel", but someone searches for "gel target", in the usual:
will not find the item.
I know there is a where with something like MATCH AGAINST, but I have tried and failed.
The fields being searched are set to TEXT.
How do you do it???
I am sure I have posted this before but cannot find my post.
If a field contains "target gel", but someone searches for "gel target", in the usual:
Code: Select all
select * from table where name = '%$search%'I know there is a where with something like MATCH AGAINST, but I have tried and failed.
The fields being searched are set to TEXT.
How do you do it???