Add support for case insensitive searching

[ekarlso]

Is there a possibility to add support for case insensitive searching in the ORM ?

Oracle uses SELECT * FROM

WHERE UPPER() LIKE ;

Or you can do WHERE LOWER() ....

ekarlso commented 12 years ago

Or do: http://askanantha.blogspot.com/2007/07/making-oracle-case-insensitive.html

spadefoot commented 12 years ago

I believe you are looking for the following:

$results = DB_SQL::select('default')->from('table')->where(DB_SQL::expr("UPPER('value')"), '=', 'text')->query();

or

$results = DB_ORM::select('model')->where(DB_ORM::expr("UPPER('value')"), '=', 'text')->query();

• © Githubissues.
• Githubissues is a development platform for aggregating issues.

[ekarlso]

Or do: http://askanantha.blogspot.com/2007/07/making-oracle-case-insensitive.html

[spadefoot]

I believe you are looking for the following:

$results = DB_SQL::select('default')->from('table')->where(DB_SQL::expr("UPPER('value')"), '=', 'text')->query();

or

$results = DB_ORM::select('model')->where(DB_ORM::expr("UPPER('value')"), '=', 'text')->query();