“What will you do if one day some one ask you to find single string in all databases, all tables and in all columns?”
— This was asked to me once. There is some string in the database but I do not know where. There was a task to find an user’s details which is in the database which consists of many tables. And all I know is only the user name and do not know any other details. How am I supposed to find that string? I do not want to write some complex SQL for this. Digging more into this, I came across few GUI tools for MySQL which have good search feature.
So I am writing this blog about search feature in those tools. I shortlisted three client application for MySQL:
1) SQLyog
2) phpMyAdmin
3) HeidiSQL
…
[Read more]