[Resolved] Multiple Like

[ph3n0m]

I am developing a search system that will accomodate for partial search and suggested results based on a users input - where they can enter a word and it returns based on that word, if they mis-spell a word it will return the results based on the first and last letter of the search string

So is it possible to do the following query

$sql = "SELECT * from test WHERE itemName LIKE ('$f%$f2' OR '%$itemName%')";

$f%$f2 - where $f is the first letter of the search string and $f2 is the last

and obviously %$itemName% is a wildcard search based on the full string

[LordShryku]

$first = substr($itemName, 0, 1);
$last  = substr($itemName, -1);
$sql   = "SELECT * 
            FROM test 
           WHERE itemName LIKE '%".$itemName."%'
              OR itemName LIKE '".$first."%".$last."'";

[ph3n0m]

Thank you very much LordShryku, had a feeling it was something I had over-looked