case insensitive

[Anon]

Hey,

I am connection to an Informix database and I am trying to return a results with case insensitive. Here is my code....
$keywordQuery=ifx_query("select * from webSearch where keyword LIKE UPSHIFT('%$query%') or desc LIKE UPSHIFT('%$query%')", $dbConnection);

But it is not working...please help if you can..

dr

[Anon]

You need to UPSHIFT() the columns also to make your search insensitive. What you are doing is just comparing what is in the column against an uppercased value.

$keywordQuery=ifx_query("select * from webSearch where UPSHIFT(keyword) LIKE UPSHIFT('%$query%') or UPSHIFT(desc) LIKE UPSHIFT('%$query%')", $dbConnection);