How to Select Individual Records From MySQL Table Tutorial

Learn how to select particular records from a MySQL table

As well as showing the whole database table, PHP can be used to select individual records, or records which match certain criteria. To do this you must use a variation of the SELECT query. To display the whole table you can use:

If you just want to select records which have value=1 in the field1-name row you would use the following query:

In the same way you could select records based on any field in the database. You can also search in more fields by adding more:

sections into the query.

For example, the following query will select all records which have value=1 in the field1-name row and value=2 in the field2-name row:

For further reference you can visit the official websites of PHP and MySQL.