PHP/MYSQL function to ignore case?

[Archbob]

lets say I like a statement like this:
$r="SELECT * FROM cl_entries where EntryName or Description LIKE '%$look%'";

How do I make the search not case sensitive?

[cgraz]

according to mysql documentation, mysql searches are case insensitive.

http://www.mysql.com/doc/en/Case_sensitivity.html

Cgraz

[Arc]

the LIKE keyword will find matches that are ot case sensitive.. if you want it to be case sesnitive use the = sign.

$r="SELECT * FROM cl_entries where EntryName or Description LIKE '%$look%'"; Not case sensitive

$r="SELECT * FROM cl_entries where EntryName or Description = '%$look%'"; Is case sensitive

and also i dont think you can do what your trying to do(maybe you can) But "where EntryName or Description = '%$look%'";"
Should be "where EntryName = '%$look% or Description = '%$look%'";

[nnichols]

When using the LIKE comparison in MySQL the query is case-insensitive by default, but if the column you are comparing is BINARY then the query will be case-sensitive. Likewise if the BINAY cast is used.

So you need to make sure that the fields' datatypes are not set to BINARY.

BTW - that query structure will not work as you expect with mysql it will query based on "Description" and ignore "EntryName".

You need to use -

SELECT * 
FROM cl_entries 
WHERE EntryName LIKE '%$look%' 
OR Description LIKE '%$look%'

Hope this helps 😉