Sql

SELECT * FROM `table` WHERE LOWER(`Value`) = LOWER("THE_VALUE")

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

When searching for partial strings in MySQL with LIKE you will match case-insensitive by default.

SELECT name FROM users WHERE name LIKE 't%'

PREVIOUS	NEXT

Code Example
Sql :: grant create db postgres
Sql :: delete vs truncate sql server
Sql :: sqrt(i)
Sql :: list foreign key oracle
Sql :: mariadb create view
Sql :: graphql
Sql :: power query datetime to date
Sql :: mysql default port number
Sql :: delete from select postgresql
Sql :: replace content value from old to new sql
Sql :: full outer join postgres
Sql :: mysql nested query
Sql :: if else sql
Sql :: between date in sql server
Sql :: postgresql variable in query
Sql :: isnull in sqlite
Sql :: mysql sql.gz
Sql :: SQL Syntax of INNER JOIN
Sql :: vi set sql syntax
Sql :: azure check access to sql database
Sql :: md5 encode oracle
Sql :: calculer pourcentage mysql
Sql :: postgres between dates
Sql :: uuid sqlalcomany
Sql :: sql track modification
Sql :: sql union
Sql :: keys in sql with example
Sql :: import sql file to mysql db using shell commands
Sql :: mysql create table
Sql :: sql server epoch to datetime