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
