Split

1. split_part
   • example code = 'abc-123'

SELECT code FROMm table
WHERE split_part(code,'-',1) = 'abc'

2. regexp_split_to_array

SELECT a[1],a[2] FROM( SELECT regexp_split_to_array(code,'-') FROM table ) AS dt(a)