replace function and string comparison

Hello... Can somebody here help me...
I am using the replace function:

replace('China and china','china','Hong Kong');

I want to ignore the cases as I compare the strings... How am I suppose
to do that? Please help... thanks...
IveCal [ Do, 08 Juni 2006 10:17 ] [ ID #1347422 ]
Datenbanken » mailing.database.mysql » replace function and string comparison

Vorheriges Thema: Blowing my mind how to setup multiple mysql servers on one windows box..
Nächstes Thema: view with parameters