Prioritize phrases in mysql full text search

[Sandeep Kumar]

I'm using MySQL full text search for my application, I have a situation where I want to set relevancy according to the priority of the phrases. For example I have 3 phrases "dark blue", "medium blue" and "light blue". Now I want relevant results following this ["dark blue">"medium blue">"light blue"] presidency I.e. records having "dark blue" will show on top after that "medium blue" and in last "light blue". I've tried my times and using different ways but it does not work.

SELECT *, MATCH (searchable) AGAINST ('+(>("dark blue" @2) <("medium blue" @2) <("light blue" @2))' IN BOOLEAN MODE) as score from `collection_data` where MATCH (searchable) AGAINST ('+(>("dark blue" @2) <("medium blue" @2) <("light blue" @2))' IN BOOLEAN MODE)

This gives the matched records but not the in-order I want. searchable is a text column which contains some description of a product.