2.6.1.2.1.9. Database content search with phpMyAdmin
- Signin in phpMyAdmin.
- Select a database from the list on the left:
- Fill out the search form and click «Forward»:
- «Search words or meanings» - what you need to find.
- «Search» — search method:
- «any of the words» — lines with any of the specified words will be found.
- «all words» — lines with all specified words will be found.
- «exact match as substring» — lines with the specified fragment will be found.
- «exact match as whole field» — lines with fields that are equal to the specified fragment will be found.
- «regular expression» — search based regular expressions, allowing you to set more complex rules.
- «In tables» — tables to be searched (use «Choose all» to search the entire database).
- The search results will display a list of tables by which the search was performed, and the number of rows found in each of them:
- «Show search parameters» - expand the form from the previous step and change the search parameters.
- «Overview» — view and edit found strings.
- «Delete» — removes the found rows from the table.