The ANSI ISO standards have a predicate for this! SIMILAR TO is based on the POSIX version of grep, which means the wildcards are keywords bracketed by colons. We picked it based on...

>> I have a [JOB] table that may reference multiple objects (by integer ID) each stored in a different table <<

singular table name? This tells us you have...

Tables are not sorted, by definition. Queries return tables, by definition. Well, actually that’s not true. I could do a query to produce a non-table by not including a key....

I think it’s an excellent question 🙂, and I wish more people would ask it. The first obvious question is “what the heck is this thing supposed to do?”...

Please don't use SELECT * in production code. I also hope you know table is...