Selecting all variations of job title in a list - Mailing list 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




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Wal streaming
Next
From: Ron Johnson
Date:
Subject: Re: Selecting all variations of job title in a list