Modify php script for search results

CLOSED
Bids
27
Avg Bid (USD)
$74
Project Budget (USD)
$30 - $250

Project Description:
I have a php script that searches my database. I need it modified so that it does a better job at searching for results. Right now if it has one extra word it doesn't find anything. I need something that searches smarter.

This is what I currently have

$sql = "select * from questions where (Question LIKE '%$quest_search%' OR Answer LIKE '%$quest_search%') AND (active='yes')";
$result = mysql_query ($sql);
$count = mysql_num_rows( $result );

if($count == "0"){
$sql = "SELECT * FROM questions WHERE MATCH(Question,Answer) AGAINST ('$quest_search' IN BOOLEAN MODE) AND (active='yes')";

}

Skills required:
MySQL, PHP
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 34
in 0 days
$ 50
in 1 days
Hire linuxfreak1985
$ 309
in 5 days
Hire farhaoui
$ 33
in 1 days
$ 55
in 2 days
$ 45
in 1 days
$ 155
in 3 days
$ 34
in 1 days
$ 34
in 0 days
$ 63
in 1 days