Query All Tables For All Fields Containing Value

Query All Tables For All Fields Containing Value

So I'm trying to figure out where this value is stored in this database.
Is there a way to query across all tables in the database and return all
rows that contain a certain value where the field name that would contain
that certain value is unknown?
For example:
select * from * where unknown_field_name = 'x'