Selecting all variations of job title in a list

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Selecting all variations of job title in a list
Date: 2025-11-25 16:33:07
Message-ID: c5296761-2f10-a59b-ad16-a0189e57cd5a@appl-ecosys.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2025-11-25 16:49:36 Re: Selecting all variations of job title in a list
Previous Message Adrian Klaver 2025-11-25 15:54:17 Re: Wal streaming