find substring in postgresql code example
Example 1: postgresql contains
SELECT id FROM TAG_TABLE WHERE 'aaaaaaaa' LIKE '%' || tag_name || '%';
Example 2: postgresql certain first 4 characters in string
SELECT employee_id,first_name,
substring(first_name,1,4)
FROM employees;