Searching through a database with phpMyAdmin



Searching through a database with phpMyAdmin

This video assumes you've already logged in to phpMyAdmin.

Now let's learn how to use the search feature.

First, select the database you want to search...

... then click the Search tab.

Let's search the name field for the name John, using the percent sign (%) before and after our search term, as a wildcard.

This means that phpMyAdmin will search for any data containing the word john, even if it has text before or after it.

When ready, click Go.

That's it! Our search query returned one result, and the term we searched for is highlighted here.

From here we can edit, copy or delete the data... whatever the reason was that we needed to search for teh data in the first place.

This is the end of the tutorial. You now know how to use the search feature in phpMyAdmin.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Becoming familiar with databases and phpMyAdmin

Becoming familiar with databases and phpMyAdminThis video assumes you've already logged...

Copying a database table with phpMyAdmin

Copying a database table with phpMyAdminThis video assumes you've already logged in to...

Creating a table in a database with phpMyAdmin

Creating a table in a database with phpMyAdminThis video assumes you've already logged...

Deleting a table from a database with phpMyAdmin

Deleting a table from a database with phpMyAdminThis video assumes you've already...

Deleting fields from database tables with phpMyAdmin

Deleting fields from database tables with phpMyAdminThis video assumes you've already...

Powered by WHMCompleteSolution