I want to find tables in my databricks database that meet more than one condition. Mysql allows 'where' clauses to include multiple conditions like this post explains.
To use multiple conditions in databricks, I can use the following syntax, but this is an or clause:
show tables from {database} like "*2008*|*animal*"
I want to find all tables that have** both 2008 and animal** in the name. Thank you in advance for your help.