rondog Posted December 7, 2010 Share Posted December 7, 2010 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 Quote Link to comment Share on other sites More sharing options...
requinix Posted December 8, 2010 Share Posted December 8, 2010 Add an ORDER BY using the exact same MATCH/AGAINST clause (but without the IN BOOLEAN MODE). Descending order. Quote Link to comment Share on other sites More sharing options...
rondog Posted December 8, 2010 Author Share Posted December 8, 2010 Add an ORDER BY using the exact same MATCH/AGAINST clause (but without the IN BOOLEAN MODE). Descending order. That worked dude, thank you! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.