Selecting all variations of job title in a list
Rich Shepard <rshepard@appl-ecosys.com>
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Date: 2025-11-25T16:33:07Z
Lists: pgsql-general
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? TIA, Rich