Companies can have slightly different titles for the same job; for example (using abbreviations). 'Asst Gen Mgr.', 'Env Mgr,', 'Gen Mgr,'. 'Mgr,', 'Plant Mgr.'
I want to select all people table rows that contain these varieties. I know the 'like' operator uses '%' as a wildcard, but is not accepted in an 'in' list.
Is there a way to use a multicharacter wildcard in an 'in' list?
Maybe regex_match() with a bunch of OR clauses.
In bash, I'd do something like:
grep -E ' ^Asst Gen Mgr.*|^Env Mgr.*|^Gen Mgr.*|^Mgr.*|^Plant Mgr..*' foo.txt
