0
debugger posted
= operator with comparision in mysql ,means not exact match
more explanation :
$terms=array("debug ","data ","secuirty ")//search term , entered with trailing spaces
foreach($terms as $term){
print_r(mysql_fetch_assoc(mysql_query("select count(*) terms where `title`=$term")));
}
i have database table with name of "terms" and it have "debug" title , still it matching with traling space and give me "1" record for
so it should exact matche with '=' operator but it matching with same value with trailing spaces.
'debug'='debug ' -> postive
how can i get exact match for trailing spaced string in mysql with '=' or without '=' ?