Hi Folks!

So i've got the basic jist of how the boolean searches for full text myisam databases work, And well it works pretty dang good!

One small gripe that I have a concern with and thats literal string searching.

By default when you type in a search, For example the word "QUIT" it literally only finds a word that matches exactly "QUIT".

However, I would like to figure out somehow to automatically add wildcard to the end of that to take any result with the word quit in it, Such as "QUITE" or "QUITS" or even "QUITESSON" (Dont think thats a word, but example).

    Again.. I'm stumped all night. I post to ask for help, and then 20 minutes i figure it out... Here's what i did if anyone else wonders.

    //Get the search criteria from form and add trailing Space
$searchstring= "$_GET[searchstring] ";
//Replace all spaces with Asterix and space so that all words are treated as wildcard
$searchstring=str_replace(" ", '* ', $searchstring);
//declare my query.
$query = "SELECT * FROM job_tracking.board INNER JOIN job_tracking.users ON board.user = users.USER_ID WHERE MATCH (subject, body, emp_ref, user, NAME) AGAINST ('$searchstring' IN BOOLEAN MODE)";
      Write a Reply...