Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE myarea (
    area_name text
);

INSERT INTO myarea VALUES
('MyAREA'), ('myarea'), ('yourarea')

CREATE TABLE

INSERT 0 3

SELECT * FROM myarea
WHERE area_name = 'myarea';

area_name

myarea

SELECT 1

SELECT * FROM myarea
WHERE area_name ILIKE 'myarea';

area_name

MyAREA

myarea

SELECT 2

SELECT * FROM myarea
WHERE area_name ILIKE '%area'; -- pattern matching

area_name

MyAREA

myarea

yourarea

SELECT 3

SELECT * FROM myarea
WHERE lower(area_name) = lower('MyAREA'); 

area_name

MyAREA

myarea

SELECT 2