Section 24.4.2 WHERE Clause

• The optional WHERE clause (p. 1053) in a query specifies the selection criteria for the query. The basic form of a query with selection criteria (p. 1052) is

Click here to view code image

SELECT columnName1, columnName2, ... FROM tableName WHERE criteria

• The WHERE clause can contain operators <, >, <=, >=, =, <> and LIKE. LIKE (p. 1053) is used for string pattern matching (p. 1053) with wildcard characters percent (%) and underscore (_).

• A percent character (%; p. 1053) in a pattern indicates that a string matching the pattern can have zero or more characters at the percent character’s location in the pattern.

• An underscore (_ ; p. 1053) in the pattern string indicates a single character at that position in ...

Get Java™ How To Program (Early Objects), Tenth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial