2.6.1.2.1.9. Database content search with phpMyAdmin

  1. Signin in phpMyAdmin.
  2. Select a database from the list on the left:
  3. 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).
  4. 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.
Content