מאגר מידע

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.

?האם התשובה שקיבלתם הייתה מועילה

מאמרים קשורים

Renaming database tables with phpMyAdmin
Renaming database tables with phpMyAdmin This video assumes you've already logged in to...
Deleting a table from a database with phpMyAdmin
Deleting a table from a database with phpMyAdmin This video assumes you've already logged in to...
Exporting databases and tables with phpMyAdmin
Exporting databases and tables with phpMyAdmin This video assumes you've already logged in to...
Importing databases and tables with phpMyAdmin
Importing databases and tables with phpMyAdmin This video assumes you've already logged in to...
Running SQL queries on a database with phpMyAdmin
Running SQL queries on a database with phpMyAdmin This video assumes you've already logged in to...