SQL Query Question

[hasek522]

I am creating a search for my website using FULLTEXT in sql but am having trouble with a query.  Here is the code that creates the search:

 

 

$search = '%' . $search . '%';

$sql = "SELECT * FROM stylists WHERE MATCH(firstname, lastname,address, city, salon, specialty) AGAINST ('" . $search . "');";

 

when ever i run this if im searching for "Jason" and type "Jason" it finds it no problem.  But say I type "Jasonb" it dosnt find "Jason".  Should the two wild cards i attach to the search variable fix that problem?  Or am i missing something else.

[DarkWater]

You aren't supposed to use wildcards with FULLTEXT.

[hasek522]

so is there any way to achieve a similiar result using FULLTEXT?

[Barand]

Have you set up a fulltext index?

[hasek522]

ya i did and the query works but its not achieving the results i was looking for.  I was hoping that a search for "Sand" would turn up "Sandy"

[Jabop]

Make sure that none of these apply to your scenario:

http://dev.mysql.com/doc/refman/5.0/en/fulltext-restrictions.html