Do not Care about UpperCase or LowerCase

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
kapil1089theking
Forum Commoner
Posts: 46
Joined: Wed May 28, 2008 1:51 pm
Location: Kolkata, India
Contact:

Do not Care about UpperCase or LowerCase

Post 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?
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Do not Care about UpperCase or LowerCase

Post by jaoudestudios »

Code: Select all

...WHERE text LIKE '%leaf%'
Post Reply