Code: Select all
SELECT GID, Descript FROM Ingrediences WHERE MATCH(Descript) AGAINST ('Apple')Apple as shortest should be on top followed by e.g. "Apple, fresh" and "Apple, fresh tinned"
Can that be done by the query or do I have to resort in php?
Moderator: General Moderators
Code: Select all
SELECT GID, Descript FROM Ingrediences WHERE MATCH(Descript) AGAINST ('Apple')Code: Select all
... ORDER BY LENGTH(Descript)