Today i am facing a problem not an issue, i googled but not found any appropriate method to compare more than 20 or 50 columns together in sql server, MYSQL. i.e. if i have a query like
select * from table1 where (col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,col14,col15,col16,col17,col18,col19,col20) in ('test')
that's means records return only when at least one of the column should have 'test' value.