how you make a mysql query to be exactly accurate

[dbradbury]

as ive tried with two '=' and it found that as a mistake..

$artist = mysql_query("SELECT * FROM phpbb_forums WHERE forum_name='$a'");

 

but i want the forum name to be exactly!! or tis the default?

[br0ken]

the equality operator (equals sign) checks for an exact match. If you have space on the end or the case is different then a match will not be returned. To get inexact matches you could convert the text to lower case using LOWER or use the LIKE operator.