Select multiple like named fields with expression

Question

So I have like fields like:

Home Zip
Business Zip
Mailing Zip

How could I do something like this (match any field that has Zip):

SELECT ILIKE "%Zip"
FROM db_tbl
WHERE condition = 'foo'

Here is a good answer to your question: http://stackoverflow.com/questions/5274594/sql-select-with-column-name-like — hspain, Aug 04 '11 at 14:22
Thanks, post it as the answer and I will accept, as it leads to the answer — Phill Pafford, Aug 04 '11 at 14:27

score 1 · Accepted Answer · answered Aug 04 '11 at 14:41

1

Here is a good answer to your question:

stackoverflow.com/questions/5274594/

To summarize, standard SQL doesn't quite support that functionality, but you can get it somewhat working with a little work.

answered Aug 04 '11 at 14:41

hspain

17,528
5
19
31

score 0 · Answer 2 · answered Aug 04 '11 at 14:28

0

You can't. You can chain multiple LIKE statements with an OR, but SQL deals with data and not metadata, so there is no shortcut to 'search any field with X string for blah' anywhere in the SQL specification (or any SQL derivative I have ever used).

answered Aug 04 '11 at 14:28

Gregory A Beamer

16,870
3
25
32

Select multiple like named fields with expression

2 Answers2