PHP MySQL Where clause

WHERE clause is used to filter records.

WHERE clause

The WHERE clause is used to extract records that meet specified criteria.

Grammar

SELECT column_name(s)FROM table_nameWHERE column_name operator value

To learn more about SQL, visit our SQL Tutorial.

In order for PHP to execute the above statement, we must use the mysqli_query() function.This function is used to send queries or commands to a MySQL connection.

Example

The following example will select all rows from the "Persons" table where FirstName='Peter':

";}?>

The above code will output:

Peter Griffin