We use cookies
We use cookies to optimize our website. By continuing to browse the site, you agree to our use of cookies.
New design
Control panel
  • Русский
  • Українська
  • English
  • UAH
  • USD
  • RUB
  • EUR
  • 0-800-307-307 Hotline
  • +38 (044) 392-74-33 Kiev
  • +38 (057) 728-39-00 Kharkiv
  • +38 (056) 794-38-31 Dnipro
  • +38 (032) 229-58-93 Lviv
  • +38 (048) 738-57-70 Odessa
  • +38(093) 170-15-42  Life
  • +38 (067) 400-88-44 Kievstar
  • +1(888)393-24-51  USA, Toll free
  • +44(131)507-01-14  Great Britain
  • +7 (499) 348-28-61 Moscow

2.7.2.1.9. Searching database content with phpMyAdmin

To search the contents of a database using phpMyAdmin, do the following:

  1. Select a database from the list on the left:
  2. Fill out the search form and click "Forward»:
    • In field "Search words or meanings»Indicate what you want to find.
    • In the block "Search»Select a search method:
      • «any of the words"- lines containing any of the specified words will be found.
      • «all words"- lines containing all specified words will be found.
      • «exact match as substring"- lines containing the specified fragment will be found.
      • «exact match as whole field»- construction sites with fields equal to the specified fragment will be found.
      • «regular expression»- search based on regular expressions, allowing you to set more complex rules.
    • In the block "In tables»Mark the tables by which you want to search, or click«Choose all"If you want to search the entire database.
  3. 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:
    • The button "Show search parameters»You can expand the form from the previous step and change the search parameters.
    • Using the button "Overview»You can view and edit the found lines.
    • Button "Delete»Removes found rows from the table.