Re: Selecting all variations of job title in a list - Mailing list pgsql-general

From Rich Shepard
Subject Re: Selecting all variations of job title in a list
Date
Msg-id 1f9412d8-2e66-b037-127e-872464bd65cc@appl-ecosys.com
Whole thread Raw
In response to Re: Selecting all variations of job title in a list  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Selecting all variations of job title in a list
List pgsql-general
On Tue, 25 Nov 2025, Adrian Klaver wrote:

> You will need to be clearer about what you want.
>
> If it is to fetch titles with Mgr in the name then it would be simple:
>
> select * from people_table where title ilike '%mgr%';
>
> If it is something more selective you will need to provide a more detailed 
> example.

Adrian,

I thought my example was clear: there are modifiers to job titles such as
'Manager,' 'Vice President,' 'Engineer.' That's why I asked if the
`like/ilike' modifier would work in a list passed to the `in' command.

Rich



pgsql-general by date:

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