Hi
I am trying to make a script, that can turn a search string, into a SQL query, but I can't find out how.
First I looked at the Fulltext-Search at mysql.com
It works fine, but there are two problems.
The first is, that it have to take everything in the search, also if it is in more than 50% of the content.
The second is, that I need the "or" operator.
What i am looking for then, is a function/script, that can turn a string, ex. "pork and onion not garlic", into "table like '%pork%' and table like '%onion%' not like '%garlic%'
Does someone have a script like this?
regards
Christoffer
