[thelist] SQL wildcards for columns

Rich Osborne R.M.Osborne at exeter.ac.uk
Wed Oct 13 11:34:27 CDT 2004


Hi all,

Anyone know if it's possible to use a wildcard after WHERE in a select
clause like this:

SELECT * FROM main WHERE * LIKE 'something'

i.e. therefore searching every column in the table and returning all rows
with any match in any column? I think not, but it would be very handy!

Rich Osborne



More information about the thelist mailing list