Find value in any column in a table

[Adil]

Hi,

I'm not sure if this is a possible scenario, but is there, by any chance a way to query all the columns of a table for searching a value? 

Explanation: I want to search for a specific value in all the columns of a databricks table. I don't know which column that value might be present, or not. I just am not sure what column holds that value. 

Thoughts?

[sashiDatabricks]

I also have this same requirement now and cant find the solution for this yet. Any help would be good. thanks