Searching MySQL Database

wxdqz

New Member
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!!
 
Back
Top