Sql

using ILIKE instead of LIKE

SELECT id 
  FROM groups
 WHERE LOWER(name)=LOWER('Administrator')

-- Postgresql case insensitive:
SELECT * FROM people WHERE name ILIKE 'JOHN'
-- John
-- JOHN
-- john

PREVIOUS	NEXT

Code Example
Sql :: 1422: Explicit or implicit commit is not allowed in stored function or trigger
Sql :: connecting to postgresql on windows amd ubuntu 20.04
Sql :: what is relational database
Sql :: foreign key on table oracle
Sql :: sql select most frequent value in group
Sql :: local database sql
Sql :: how to delete user sql server
Sql :: max length found in mysql
Sql :: mssql describe stored procedure sqlcmd
Sql :: order by sql query
Sql :: display first three characters sql
Sql :: mysql delete older duplicates
Sql :: when matched in sql server
Sql :: T sql less than date
Sql :: sql max min
Sql :: else if sql
Sql :: pl sql create function
Sql :: how to get information about data types in postgreSQL
Sql :: back up stored procedures mysql
Sql :: unique sql
Sql :: check ksql db health
Sql :: oracle cast boolean to varchar2
Sql :: postgres show table schema
Sql :: how to login to mysql in homestead
Sql :: mysql average from two table
Sql :: plsql find location of procedure
Sql :: duplicate key value violates unique constraint "django_admin_log_pkey"
Sql :: how to declare variable date in mysql
Sql :: select all columns except one sql
Sql :: cte in sql server