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!!
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!!