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 :: mysql query with sql to get the next row
Sql :: sql character index
Sql :: mysql order by multiple columns
Sql :: mysql count multiple columns in one query
Sql :: get number of columns sql
Sql :: error code 1215 cannot add foreign key constraint
Sql :: query by column for substring sql
Sql :: mysql identified by syntax error
Sql :: bigquery add days to date
Sql :: oracle convert run duration to number
Sql :: sqlite unique multiple columns
Sql :: mysql ilike
Sql :: q operator in plsql
Sql :: how to ascending order in sql
Sql :: sql stored procedure update if parameter is not null
Sql :: select random sample sql
Sql :: call postgres function
Sql :: alter or change postgresql sequence counter
Sql :: how to get initials in sql
Sql :: mysql count rows returned
Sql :: postgresql if else endif
Sql :: mysql case when in select
Sql :: reset keys in sql
Sql :: t-sql check if data exists
Sql :: sum mysql
Sql :: oracle enable chain
Sql :: oracle avg
Sql :: select odd records sql
Sql :: sql search all tables for attributes
Sql :: phone number regex sql