I have this query :
Code: Select all
$res = mysql_query('SELECT id_plato,plato_ES,plato_FR,plato_EN, MATCH(plato_ES, plato_FR, plato_EN) AGAINST ("'.$q.'") AS score FROM a_platos WHERE id_plato IN '.$bout_de_requete.' and MATCH (plato_ES, plato_FR, plato_EN) AGAINST("'.$q.'") ORDER BY score DESC');
$bout_de_requete = a list of ID to look in
my question :
is it possible to search with accent INSENSITIVE ?
the database (mysql 5.1.50) keep data in 3 languages (spanish, french and english)
the database is utf8_general_ci, all the tables the same, my php script work with utf8 too...
wich is the best approach to keep the query MATCH AGAINST (not boolean) and get result with accent INSENSITIVE ?
if not possible, wich solution we have ? (I really need the score to sort the results)
thanks guy !!