Full Text sort order question
Posted: Wed Jun 29, 2005 4:44 am
I am using following full text serach
The list contains all kinds of Apple entries that I like to be sorted by string length.
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?
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?