Entry

Is there some way to find a certain value that could be in any column in a table ?

Feb 20th, 2008 23:05
dman, Matt Chatterley, Welington Dias, http://sturly.com

The answer is 'maybe'.
You can always construct an ugly, but functional query such as:
SELECT * FROM Table1
WHERE ColumnA = Value
OR ColumnB = Value
OR ColumnB = Value
However, it depends upon what exactly you are trying to do - in theory,
in a well ordered relational database, each column represents a distinct
'thing', and therefore, knowing the type of your value (which thing it
represents), you should only have to search one column.