To search every row in every table in a database for a value
Use the phpmyadmin ‘Search’ feature.
Select your database (be sure you do have a DB selected and not a table)
Click ‘Search’ tab
Choose the search term you want
Choose the tables to search