On Tue, Nov 25, 2025 at 11:33 AM Rich Shepard <[email protected]> wrote:
> 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? > Maybe regex_match() with a bunch of OR clauses. In bash, I'd do something like: grep -E ' ^Asst Gen Mgr.*|^Env Mgr.*|^Gen Mgr.*|^Mgr.*|^Plant Mgr..*' foo.txt -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
