Archive:PHP and MySQL Programming/Basic Queries: Difference between revisions
| Line 19: | Line 19: | ||
Example : | Example : | ||
mysql> SELECT * FROM books | mysql> SELECT * FROM books; | ||
mysql> SELECT Title, Author` | mysql> SELECT Title, Author` | ||
FROM books | FROM books | ||
WHERE Year > 2001 | WHERE Year > 2001 | ||
AND Year < 2006 | AND Year < 2006 | ||