Home Yellow Pages Movies Classifieds Jokes Jobs Free Hosting Videos

MySQL Where

To select only data that matches a specified criteria, add a WHERE clause to the SELECT statement.


SELECT column FROM table WHERE column operator value.

The following operators can be used with the WHERE clause:

Operator Description
= Equal
!= Not equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal

BETWEEN Between an inclusive range LIKE Search for a pattern.

Note: SQL statements are not case sensitive. WHERE is the same as where.

To get PHP to execute the statement above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection.


The following example will select all rows from the "Person" table, where FirstName='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 person WHERE FirstName='Nancy'");
while($row = mysql_fetch_array($result))
echo $row['FirstName'] . " " . $row['LastName'];
echo "<br />";

The output of the code above will be:

Nancy Varghese

Back to Home
BizHat.com   Bookmark   Astrology   Chat Room   Classifieds   Computer   Downloads   Directory   Dating   Domain Tools   Education   eCards   Finance   Forums   Freelance Work   Free Hosting   Free Mail   Gallery   Games   Guest Book   Greeting Cards   Ham Radio   Health   Home Business   Hosting Tutorials   Hosting Directory   India   Jobs   Jokes   Kerala   Matrimonial   Music   Movies   News   News Letter   Recipes   Real Estate   Search   SMS   Tourist Guide   Top 100 Sites   Vote Us   Yellow Pages   Arthunkal Church   Site Map