Case insensitive sql

-- find everyone with  first_name contains d case insensitive manner
Make everthing either lower or upper case

SELECT FIRST_NAME , LAST_NAME 
FROM EMPLOYEES 
WHERE LOWER(FIRST_NAME) LIKE '%d%' ;

Similar codes

14 votes136 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote145 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
4 votes173 views3 answers
Postgres drop all tables
SQL
0 vote95 views2 answers
Delete query sql server
SQL
0 vote167 views1 answer
Pl sql search in all packages
SQL
8 votes134 views1 answer
Unique vs primary key
SQL
0 vote140 views1 answer
Mysql select last 15 minutes
SQL
0 vote160 views1 answer
Liquibase update row
SQL
5 votes152 views2 answers
Oracle rename table
SQL
0 vote154 views1 answer
Select multiple row from primary key sql
SQL