Page 1 of 1

Do not Care about UpperCase or LowerCase

Posted: Tue Jun 16, 2009 8:23 am
by kapil1089theking
I want to write a PHP program where I will get a string from a form as POST technique.
Suppose $string is my text
I dont wanna bother all the time is it in uppurcase or lowercase, It may even use MYSQL

Suppose I am searching for "LeAf" in MySQL
I must Get leaf,lEAf, etc anything like the same

Or for PHP suppose I am finding the word LeaF is the text which contains leaf must return its presence.

If you get my point I want to confirm again:
I dont really want to bother about the cases for the whole of my PHP program including MYSQL queries.

How to achieve that in the best Manner?

Re: Do not Care about UpperCase or LowerCase

Posted: Tue Jun 16, 2009 9:22 am
by jaoudestudios

Code: Select all

...WHERE text LIKE '%leaf%'