Retrieving the Data - Database Design Manual: Using MySQL for Windows - page 57

Figure 6.6 Without the WHERE clause.

Figure 6.6 which is the results of the SELECT statement when the WHERE clause is omit-
ted.
The condition in the WHERE clause can check for one condition or many, and can com-
prise many different formats. For example, if we were searching for a text string we would
put the string within quote marks as follows:

SELECT *
FROM

webpage

WHERE title = “Home”

The current version of MySQL will accept strings within quote marks (“”) or apostrophes
(''). This may change in future versions but whichever you decide to use make sure that you
consistently use the same throughout all of your queries.

MySQL Operators

As well as =, MySQL supports other operators. Some of these are shown in Table 6.1.

Table 6.1 Some MySQL Operators.

Operator Meaning

= equal

<> not equal

!= not equal

<= less than or equal

< less than

>= greater than or equal

> greater than

<=> null safe equal