One of my favorite features of HeidiSQL is its "Find text in database", see https://www.heidisql.com/forum.php?t=1006
It'll search through all text fields of all tables of whichever database you specify for a given string, and displays a nice per-table summary for each matching record. I haven't found anything like this in any other DB client.