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