How in MySQL to check to see if two expression are equal irrespective of their case?

[majorgood]

Hello,

How does one in MySQL check to see if two values are equal or not irrespective of their case?

I mean I have an expression like:
X1 = 'Hotels in Boston'

And a field in MySQL DB named 'keywords'.
which can contain: 'hotels in boston'

I want these two to match, irrespective of their case.
How do I do this via a query command like:

SELECT COUNT(id) AS kw_ads FROM keywords WHERE keywords = '$X1'

Regards,

[longneck]

use LIKE instead of =

[majorgood]

Aha!
That simple!
Cool

ThanX.

use LIKE instead of =