如何查找其中包含某些行值的列/表

I'm trying to fetch all the table name with certain column value inside it. For example, table A has 3 columns, one of these columns has the value 'testvalue' table b has 6 columns, one of these columns has the value 'testvalue'I'm trying to fetch all the table name with cer