Selecting all variations of job title in a list
| От | Rich Shepard |
|---|---|
| Тема | Selecting all variations of job title in a list |
| Дата | |
| Msg-id | c5296761-2f10-a59b-ad16-a0189e57cd5a@appl-ecosys.com обсуждение исходный текст |
| Ответы |
Re: Selecting all variations of job title in a list
Re: Selecting all variations of job title in a list Re: Selecting all variations of job title in a list Re: Selecting all variations of job title in a 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 по дате отправления: