Mysql how to orderby matching query string with Full-Text Searches MATCH AGAINST

Ex I have table:

Id Name
1  bcd def abc
2  def abc
3  abc

​x
 
Id Name1  bcd def abc2  def abc3  abc​

I search by Boolean Full-Text Searches like

SELECT * FROM table WHERE MATCH (name) AGAINST ('abc*' IN BOOLEAN MODE)

 
SELECT * FROM table WHERE MATCH (name) AGAINST ('abc*' IN BOOLEAN MODE)​

how to order by if abc is first of text result order like this:

Id Name
1  abc
2  def abc
3  bcd def abc

 
Id Name1  abc2  def abc3  bcd def abc​

if ‘abc’ postion is not a head will be pushed down

Answer

You can use locate():

order by locate('abc', name)

 
order by locate('abc', name)​