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

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

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. 

Thanks Hubert, using this wild card seems really helpful