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???