SELECT statement

[rhysmeister]

I want a sql statement that basically says...

&quot;select all from <tablename> where <anycolumn> is like <condition>&quot;

Any ideas?

 

[r937]

instead of the word &quot;all&quot;, use an asterisk

rudy

 

[rhysmeister]

I don't mean the all section of the staement, basically I want to search all the columns in various tables for a keyword, something like...

SELECT * FROM <tablename> WHERE <allcolumns> LIKE <%keyword%>;

 

[r937]

you will have to mention each column

where foo like '%zzz%'
or bar like '%zzz%'
or qux like '%zzz%' ...

 

[rhysmeister]

Just thought there may have been a quicker way, thanks!

Rhys

 

[rwheels]

It's tricky, but if you create a cursor (loop) and use the system tables (which is where you find the column names, etc) you can do this.