not case sensitive pattern matching

searain

how can i do a "not case sensitive pattern matching"?

this sql statment will return case sensitive pattern matching results.

$sqlselectproduct="SELECT * FROM PRODUCTS WHERE PRODUCTNAME LIKE '%$searchkeywords%' ORDER PRODUCTNAME";

such as

if product names are "Ford 2003", "Ford 2002", if the searchkeyword is "Ford", then "Ford 2003", "Ford 2002", but if the searchkeyword is "ford", then they are not going to be returned.

how can i get a "not case sensitive pattern matching"?

Thanks.

By the way, I am using Interbase. Could anyone direct me to a Forum of interbase as useful as this forum for php?

I went to Interbase SQL newsgroup, the Borland tech usually will tell me go to read the manual. I would like to find a fourm for interbase as this for php, that I can find help without always being told go to read manual.

Maybe some firebird forum will do too.

thanks.

searain

correction in my sample codes above.

$sqlselectproduct="SELECT * FROM PRODUCTS WHERE PRODUCTNAME LIKE '%$searchkeywords%' ORDER BY PRODUCTNAME";

searain

$sqlselectproduct="SELECT * FROM PRODUCTS WHERE UPPER(PRODUCTNAME) LIKE UPPER('%$searchkeywords%') ORDER BY PRODUCTNAME";

diego25

Look into the 2 different string types: text and blob. I forgot which one, but one of them does case insensitive comparisons by default.

Diego

searain

I think it might depend on the databases.

Such as MySQL's "LIKE" is default case insensitive (?).

diego25

Yeah, according to this: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#String_comparison_functions , MySQL's LIKE is case insensitive unless one of the strings is binary. What database are you using?

Diego

searain

Interbase/Firebird.