strtolower(cos) Opcje

[menic]

Jak zrobić aby pobierał dane z Mysql zapisane małymi literami. Wyglądałoby by to tak
[sql:1:f12e19f701]mysql_query( "SELECT bla FROM tabela WHERE strtolower(cos) = cos1" );[/sql:1:f12e19f701]
Oczywiście ten przykład nie działa ale chodziło mi o ukazanie problemu

[scanner]

LCASE(str)
LOWER(str)
Returns the string str with all characters changed to lowercase according to the current character set mapping (the default is ISO-8859-1 Latin1):
mysql> SELECT LCASE('QUADRATICALLY');
-> 'quadratically'
This function is multi-byte safe.
UCASE(str)
UPPER(str)
Returns the string str with all characters changed to uppercase according to the current character set mapping (the default is ISO-8859-1 Latin1):

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