The following examples show how INDEX(string_1, string_2) operates when the server character set for both arguments is KANJI1 and the client character set is KanjiShift-JIS.
| IF string_1 contains … | AND string_2 contains … | THEN the result is … |
|---|---|---|
| mnABC X | B | 4 |
| mnABC X | X | 6 |