[mySQL] Porovnaní řetězců NE case senzitive

[ripper]

nevim jak s jinym kodovanim, to si muze kazdej vyzkouset, ale minimalne s utf8 to vali v pohode:

mysql> create table forum (
    ->     id INT AUTO_INCREMENT,
    ->     jmeno VARCHAR(50),
    ->     PRIMARY KEY (id)
    -> ) TYPE=MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

mysql> insert into forum (jmeno) values
    -> ('Franta'),('PepIk'),('kamil');

mysql> select * from forum where jmeno like 'pepik';
+----+-------+
| id | jmeno |
+----+-------+
|  2 | PepIk |
+----+-------+
1 row in set (0.00 sec)