Searching fort worth vs fort collins

[rondog]

I have a search going on:

<?php
$sql 	= "SELECT * FROM video WHERE MATCH(name,description,location,keywords) AGAINST('" . mysql_real_escape_string($_POST['searchfield']) . "' IN BOOLEAN MODE)";
?>

 

I have rows that contain either "fort worth" or "fort collins" for example. When I search "fort worth" it finds all the rows including the fort collins rows. That is expected as it contains "fort". The issue is "fort collins" is showing up before "fort worth"

 

What can I do fix this? If I take out the "IN BOOLEAN MODE" part then it works, but breaks other parts of my search

[requinix]

Add an ORDER BY using the exact same MATCH/AGAINST clause (but without the IN BOOLEAN MODE). Descending order.

[rondog]

Add an ORDER BY using the exact same MATCH/AGAINST clause (but without the IN BOOLEAN MODE). Descending order.

 

That worked dude, thank you!