Skip to content



The ILIKE operator is used similarly to the LIKE operator to search for a specified pattern in a column in the WHERE clause.

The main difference between the ILIKE operator and the LIKE operator is case sensitivity. When using ILIKE, characters in a string are treated the same whether they are uppercase or lowercase.


> SELECT column1, column2, ...
FROM table_name
WHERE columnN ILIKE pattern;


drop table t1;
create table t1(a varchar(20));
insert into t1 values ('abc'), ('ABC'), ('abC');
select * from t1 where a ilike '%abC%';

mysql> select * from t1 where a ilike '%abC%';
| a    |
| abc  |
| ABC  |
| abC  |
3 rows in set (0.01 sec)