How to choose everything and everywhere?

Question

MySQL

Hello! I just can't find any solution on the Internet that would do something like this:
SELECT * FROM * WHERE * LIKE %text%
That is, I want to go through all the tables and fields without entering the names of the tables and fields. Is that possible? I hope I explained clearly.
Thank you!

Answer 1

Walk through a special service table called a catalog.
Extract from it the names of all your tables in your database.
And you make a separate request for each of them. It is possible to unite requests through UNION
But how do you imagine it in the output?
In one column you will have either numbers, or words, or dates????

Answer 2

You need to refer to INFORMATION_SCHEMA, it has information on all tables.
But in general, this is not true. Since, for the most part, the columns of the tables do not match, you need to aggregate all the data in the required form in the storage - in the same ElasticSearch. And on it already to make a request, so as not to force the base once again. During the aggregation process, it will come up that not all tables are needed, not all fields are needed, etc. (or maybe not, who knows).

Answer 3

Like this: It will be within the database. SELECT * FROM *