Like and Equal...

[ataria]

WHERE `x`='x'
and..
WHERE `x` LIKE 'x'

what is the difference?

[wildteen88]

This is not a php question but an SQL syntax question. I'll this to MySQL board in a sec

However to answer you question. WHERE `x`='x' checks for exact matches, such say x is apple it look for exact matches in the database for any rows that has apple as its value, where as WHERE `x` LIKE 'x' does not check for exact matches but close matches, so apples and apple are matches.

[keeB]

You can use like with wildcards, ala

[code=php:0]
where `x` like '%ab%'
[/code]

That will pull any field in X that contains ab at all.