Searching MySQL Database

I writing a script that will search tables for certain text but, i relized a problem, if in the data base i have "I Love Cats" and i do a

Select * from some_db where MyText like "%cats%" it won't return that is found that entry, can i do sumthing like this?

Select * from some_db where LCACSE(MyText) like "%cats";

Thanx!!

"can i do sumthing like this?

Select * from some_db where LCASE(MyText) like "%cats";"

yes, but you'd have to add another % after cats, or it will only find those records that end in 'cats'

Tip: read the article called 'slapping together a search engine' on this very site.