topic Re: Find value in any column in a table in Get Started Discussions

Find value in any column in a table

Adil — Mon, 27 Nov 2023 03:21:45 GMT

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?

Re: Find value in any column in a table

sashiDatabricks — Wed, 05 Mar 2025 19:11:08 GMT

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

Re: Find value in any column in a table

HAVIC — Tue, 02 Dec 2025 22:53:46 GMT

Select * from table as t where '1234' in (t.*)

Re: Find value in any column in a table

iyashk-DB — Wed, 03 Dec 2025 18:37:19 GMT

You can do something like this, but first run the following code in Python:

table = "my_table" value = "foo" cols = spark.table(table).columns sql = f""" SELECT * FROM {table} WHERE {" OR ".join([f"CAST({c} AS STRING) LIKE '%{value}%'" for c in cols])} """ print(sql)

, then run this sql query.

Re: Find value in any column in a table

Hubert-Dudek — Wed, 03 Dec 2025 20:48:07 GMT

Re: Find value in any column in a table

sashiDatabricks — Wed, 03 Dec 2025 22:05:32 GMT

Thanks Hubert, using this wild card seems really helpful