search, sql order by priority of the searched term ?

[yami007]

i want to sort the available words by the "searched word"...is there any way ?

<?php

$query = "SELECT * FROM ce_cour_chap WHERE nom LIKE'%$find%' ORDER BY nom";
$result = mysql_query($query);

while($search = mysql_fetch_array( $result )) 
{ 
echo $search['nom']." - ".$search["chid"]."<br/>";
}
?>

[QuickOldCar]

There is many types of sorting.

 

Please explain in what way, or in how of the sorting you desire.

[yami007]

Thanks for your time !

 

Let's assume a user typed "plan"

Regardless of the database's fields, I want to sort them by the word given "plan".

if "plan" is the first word of a sentence, it should go first even if another entry start with an a for example: "plan" should go first before "a plan"

 

- plan

- planning

- a plan

- the planning

[kicken]

Probably the best you could do with your query is using something like:

 

ORDER BY INSTR(nom, 'plan')

 

 

[yami007]

Probably the best you could do with your query is using something like:

 

ORDER BY INSTR(nom, 'plan')

 

 

 

Thank you kicken, that's what I want