FULLTEXT search ORDER BY

23 Views Asked by At

I have tabl_1 records follow:

Balvenie 12
Balvenie 13
Balvenie 14
Balvenie 15
Balvenie 16
**Balvenie 17**
Balvenie 18
Balvenie 19
Balvenie 20
Balvenie 21
Balvenie 22

How do I state the search query? with type FULLTEXT:

SELECT * FROM table_1
WHERE MATCH(title) AGAINST("Balvenie 17")
FROM view_product 
ORDER BY ??

I look forward to showing results:

**Balvenie 17**
Balvenie 12
Balvenie 13
Balvenie 14
Balvenie 15
Balvenie 16
Balvenie 18
Balvenie 19
Balvenie 20
Balvenie 21
Balvenie 22

I am trying to sort search query statement FULLTEXT search to sort - ORDER BY

0

There are 0 best solutions below