I have table which has nearly 250 columns. Nearly 150 columns are all VARCHAR. I want to search for a particular string with wildcard characters like '%sentine%' which can be in any one of the 150 columns.
Is there any way to search for a particular string in all the columns of a particular record based on their data type or something like that.
What i really want is, i want to search for a string or some characters in all the columns of a particular record and do the same for all the records.
i have to use the old and tedious style
select * from tablename
where firstcol like '%senti%' or
secondcol like '%senti%' or
onehunderedandfiftycol like '%senti%'