~drizzle-trunk/drizzle/development

Viewing changes to docs/where.rst

Make fixes to temporal docs
Make a few minor docs cleanups/fixes
Start using syntax-highlighting code blocks

added added

removed removed

The WHERE clause is used to extract only those records that fulfill a specified criterion.

Simple SQL WHERE Syntax ::

Simple SQL WHERE Syntax:

.. code-block:: mysql

SELECT column_name(s)

FROM table_name

+---------+------------+----------+----------+--------+

If you want to select only the persons living in the city "Chicago" from the table above, use the following SELECT statement: ::

If you want to select only the persons living in the city "Chicago" from the table above, use the following SELECT statement:

.. code-block:: mysql

SELECT * FROM Persons

WHERE City='Chicago'

+---------+------------+----------+----------+--------+

+---------+------------+----------+----------+--------+

+=========+============+==========+==========+========+

+---------+------------+----------+----------+--------+