Probiers doch mal so:
Code:
SELECT name
FROM products_description
WHERE language_id=2
AND (MATCH(name) AGAINST ('optiset' IN NATURAL LANGUAGE MODE)) AND (MATCH(name) AGAINST ('standard' IN NATURAL MODE))
ORDER BY (MATCH (name) AGAINST ('optiset' IN NATURAL LANGUAGE MODE)) DESC ,(MATCH(name) AGAINST ('standard' IN NATURAL LANGUAGE MODE)) DESC;
Ungetestet und von einem
SQL-Laien. Aber vielleicht eine Idee für einen Ansatz
