/SQL/How to make case insensitive in sql

How to make case insensitive in 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

16 votes352 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote378 views1 answer
Mysql backup query
SQL
2 votes324 views1 answer
Copy all values of a column to another column in sql in same table
SQL
1 vote308 views3 answers
Remove unique key from a table
SQL
17 votes307 views2 answers
How to assign date field for table in mysql
SQL
0 vote331 views1 answer
Add column in sql server ubuntu
SQL
0 vote311 views1 answer
Show all mongodb
SQL
13 votes310 views2 answers
Sqlite rename column
SQL
4 votes330 views1 answer
Describe table mysql
SQL
2 votes347 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL