Select query to find similar string on postgresql
SELECT * FROM [table name] WHERE [table field] SIMILAR TO ‘%[string]‘ –> string before
SELECT * FROM [table name] WHERE [table field] SIMILAR TO ‘[string]%’ –> string after
SELECT * FROM [table name] WHERE [table field] SIMILAR TO ‘%[string]‘ –> string before
SELECT * FROM [table name] WHERE [table field] SIMILAR TO ‘[string]%’ –> string after