psql select where like year code example
Example 1: ilike for date postgres
column::text LIKE '2011-01-%'
Example 2: postgresql like
SELECT
first_name,
last_name
FROM
customer
WHERE
first_name LIKE 'Jen%';
column::text LIKE '2011-01-%'
SELECT
first_name,
last_name
FROM
customer
WHERE
first_name LIKE 'Jen%';