CASE SENSITIVE Issue SOLVED

[eluser]alejandronanez[/eluser]
Hey everyone, how have u been ! ?

The problem is that I developed SEARCH method for my project, but SEARCH is CASE SENSITIVE, I would like to do a CASE INSENSITIVE SEARCH.

I've been working with ORACLE XE and I just can't make it.

Anyone can help me out?

Thanks in advice!

Ps. Greetings from Popayán - Colombia

[eluser]danmontgomery[/eluser]
http://askanantha.blogspot.com/2007/07/m...itive.html

[eluser]alejandronanez[/eluser]
Thanks man, It was pretty easy.

Here's my code just in case.

Code:

$where = "SELECT * FROM TABLE WHERE REGEXP_LIKE(COLUMN,'$search','i')";

$query = $this->db->query($where);