Suppose I want to search for a string in a table which has 100 columns.
Is there any way to find out in which column that string exists instead of writing

select * from table where column1 = 100 or column2 = 100 etc.?

I like following solution

for each columns in table
see whether value matches with given string