Hello,
One of my websites http://www.dole.ie has very dumb SQL.
All the SQL searches are '%keyword%' based.
This means if you search for "care assistants" you get things like "Personal assistant career" etc.
Changing the SQL to ' %keyword% ' isn't really good enough.
Can any of you think of any ways to make "care assitant", "care other words assistant", "assistant other words care" be found in a large bit of text, while at the same time ignoring things like "career assistant"?
Any help greatly appreciated.
Thank you.
