PHP's MySQL WHERE clause

PHP's MySQL WHERE clause

The WHERE clause is used to filter records.

WHERE clause
The WHERE clause is used to extract only those records that complete the specified criteria.

Grammar

SELECT column_name (s) from
table_name
WHERE column_name operator value

   
   
   

    
    
    




For example
The following example selects all rows from the "person" table, where the name = ' Peter ':
    
    
    
 
    
    
$con = mysql_connect ("localhost", "Peter", "abc123"); if (! $con) {die (' could not connect: '. Mysql_error ());} mysql_select_db ("my_db", $con); $result = mysql_query ("select * from Persons WHERE firstname= ' Peter '"); while ($row = Mysql_fetch_array ($result)) {echo $row [' FirstName ']. " " . $row [' LastName ']; echo "<br/>"; }?>
    
    
    
 
    
    
Output to.
    
    
    
Peter Griffin