How to find a specific substring in any field of any table in the database?

Question

SQL

We need to find out where in the database a certain substring is mentioned. The names of the table and the field where the mention may occur are unknown.

Answer 1

If this is how you decided to implement the search in your service, then I strongly do not advise it. Yuzai is better than Sphinx. But if it’s completely pinned down, then you’ll have to fence the bike for a specific DBMS. You get a list of tables, cycle through them, get a list of columns in each, and so on. This will be slow and not universal.