Lower case queries

[John Mun]

On a Linux box running MySql and using PHP to query I have:

SELECT DISTINCT City, EventName, State, Venue FROM catalog where category = 2 AND type LIKE '%widgets%' order by City"

In the database let's assume widgets is capitalized in some instances, not capitalized in others, with no way of knowing which letters are caps. Also assume "widgets" could be any number of terms - i.e. brackets, binders, books, etc. and I have no idea what they will be nor can I edit the database as it will impact functionality in other areas.

How can I get the query to return all records containing "widgets" regardless of which letters are capitalized? I tried using LOWER(category) with no success.

Any help is appreciated.