I have a table with a column 'name'
Can someone suggest the appropriate MYSQL query syntax to select all records from a table in which some $value has a match of 1.5 or better agains the name column.
My first stab was something like:
$query = "SELECT name,genre MATCH (name) AGAINST('$value') AS score FROM games WHERE score > 1.5";
The MYSQL documentation on returning MATCH scores is a little confusing. They say to use it like this:
"SELECT name,genre MATCH (name) AGAINST('$match') AS score FROM games MATCH (name) AGAINST('$match')"
(They use 'id' instead of 'score' in their example)
But I don't see a way to set a minimum score. Do I have to create my own function to cycle through all the returned rows via a loop and throwout the matches below a certain value?
