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

Figure 6.18 ORDER BY … DESC reverses the sort order.

Figure 6.19 ORDER BY on a different column than that returned.

into a simple clause. When this is needed, you can use the IN keyword to search against a set
of criteria. This command works as follows:

SELECT columns
FROM tablename

WHERE column IN (values)

In the above query, values is a comma-separated set of values. As an example of this we
will again select all of the webpages that begin with the word Home from our webpage
table. Using LIKE this command is:

SELECT id, title
FROM webpage

WHERE title LIKE “Home%”