Con este:
Código PHP:
SELECT *, MATCH (cupon_titulo, cupon_descripcion) AGAINST ('" . $busqueda . "' IN BOOLEAN MODE) AS coincidencias FROM cupones AND MATCH (cupon_titulo, cupon_descripcion) AGAINST ('" . $busqueda . "' IN BOOLEAN MODE) ORDER BY coincidencias DESC
Obviamente cambiando los parámetros de $busqueda
El phpmyadmin me tira:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND MATCH (cupon_titulo, cupon_descripcion) AGAINST ('asd a' IN BOOLEAN MODE) OR' at line 1