Simple select statement help

[lukep11a]

There is probably a very simple answer to this question so excuse me for sounding dim but its driving me mad, can anyone tell me how to convert the following code to select only the results exactly equal to $var rather than all values like $var:

 

$query = "SELECT * FROM directory WHERE merchant LIKE \"%$var%\"";
	$result = mysql_query($query);

	while($row = mysql_fetch_assoc($result))
	{

[ale8oneboy]

Try:

$query = "SELECT * FROM directory WHERE merchant = '$var'";

 

[lukep11a]

Thanks mate, perfect

[Maq]

For more information, be sure to check out the MySQL Manual for LIKE syntax.