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

Need to know where in DB referred to a certain substring. The table and field names where the reference may occur is unknown.
March 23rd 20 at 19:42
1 answer
March 23rd 20 at 19:44
If you're in his service decided to implement the search, it is extremely not advised. Yuzay better Sphinx. But if we are really priperlo, you have to fence a Bicycle for a specific DBMS. Get the list of tables, go for it cycle, get in each list of columns, etc. Is slow and not universal.
No, it's a one-off event. It is necessary, without going into the structure of the database, find and replace substring. It is clear that you can write a script, but I would like a team :)). Chick, and you're done. - asa.Fahey commented on March 23rd 20 at 19:47
@asa.Fahey, search by LIKE not suitable? - Ephraim_Nitzsche commented on March 23rd 20 at 19:50
@Ephraim_Nitzsche, the field name is unknown, but the asterisk there is not put:
SELECT * FROM * WHERE * LIKE '%...%' - asa.Fahey commented on March 23rd 20 at 19:53

Find more questions by tags SQL