php search wild cards

[buckeyejack]

Hi
I'm trying to write a very simple search engine to search my DB, but I'm having some troubles with the wild cards.
currently It will select the word placed into the engine, but will not recognize with plurals. current code is as follows:
<?
$db_name = "";
$table_name = "post";
$connection = @mysql_connect("localhost", "", "") or die("couldn't connect");
$db = mysql_select_db($db_name, $connection) or die ("coudnt select database");
$sql = "SELECT title FROM post WHERE description like '%$search%'";
$qry = mysql_query($sql);
echo mysql_error();
$row = mysql_fetch_array($qry);
?>
Results (title)
<?=$row["title"]?>

[Anon]

Did not quite catch, but is your problem in searching singles also when search word is plural? Like when you search for "cats", you want to get "cat" also?
If this is the problem - just remove the last "s" from the searched word - and you'll get it :-)

[Anon]

I'm sorry if I wasn't clear.
For example if I have a site that has a variety of ads in the DB, and if a user wants to use the search engine they will search for Plurals such as trucks, cameros etc.. but the person writting the ad will use singular example: I have a blue truck for sale.
Now my problem is if I search trucks there are know records found, but one exists.
NOw I realize this isnt a multiple word search engine, but it's a start.
I hope this is clear.