Thanks a lot
Method : Using phpMyAdmin’s “Search” Feature
-
Open phpMyAdmin.
-
Select your database (SuiteCRM) from the left sidebar.
-
Click on the “Search” tab in the top menu (not the one in the structure or table view).
-
In the “Words or values to search for” field, enter the string you want to search (e.g.,
'apple'
). -
Under “Inside tables”, check the box “Select all” (or manually pick the tables you want).
-
Optionally select “Find” → “at least one of the words”, or change the match type if needed.
-
Click Go.
It will then return all matching entries across all selected tables and fields.