$query = "SELECT * FROM `table` WHERE `merchant` LIKE '%keyword%'"; $result = mysql_query($query) or die ("Query failed: " . mysql_error() . " Actual query: " . $query); while ($row = mysql_fetch_array($result)) { //do stuff }