PHP Search Form

I have PHP page that needs to search through a mysql db. It returns the results on search_results.php. The problem is, it only returns exact matches. For instance, if you search for “Miller” you dont get any results, but if you look for “Miller Lite” you do. Can anyone help me out? I want it to find strings so if you enter “Miller” you will get results like “Miller Lite, Miller High Life, Miller Genuine Draft”. I’ve provided the code.

search.php

<form name="search" action="search_results.php" method="post">
 Beer Name:
 <input name="beer_name" id="beer_name" type="text" value="" size="12"/>
 <input type="submit" value="Search!">
 </form>

search_results.php

$colname_rsSearchResults = "1";
 if (isset($_POST['beer_name'])) {
   $colname_rsSearchResults = (get_magic_quotes_gpc()) ? $_POST['beer_name'] : addslashes($_POST['beer_name']);
 }
 mysql_select_db($database_connPavlishDB, $connPavlishDB);
 $query_rsSearchResults = sprintf("SELECT * FROM items WHERE name LIKE '%s' ORDER BY price ASC", $colname_rsSearchResults);
 $rsSearchResults = mysql_query($query_rsSearchResults, $connPavlishDB) or die(mysql_error());
 $row_rsSearchResults = mysql_fetch_assoc($rsSearchResults);
 $totalRows_rsSearchResults = mysql_num_rows($rsSearchResults);

Cheers!
Matt O’Connor