University IT » Web Services » Help » MySQL » Veiwing Data
MySQL with phpMyAdmin Tutorial
Index | Getting Started | Tables | Viewing Data | Updating Data | Resources
Viewing Data
Browsing
- After selecting a database and table, click on the Browse tab.
- This view shows every row in the selected table but does not nessessarily show all of them in the same page. You can simply click next page at the bottom to get to rows beyond 30.
- Click on a column heading to sort by that column.
- Click on the ">" button to view the next 30 rows.
Searching with "Select"
- You can use the Select tab to search for rows.
- Enter a value for a field and press Go to select all rows matching that value.
- To do a general search on a text field, surround the word with percent signs.
The variable "LIKE" & "=" are very much alike. The slightest difference is that when typing in "=", it searches for the only variable. Yet, "LIKE" searches anything that may have similarity.
