Index

Note to the reader: Throughout this index boldfaced page numbers indicate primary discussions of a topic. Italicized page numbers indicate illustrations.

Symbols & Numbers

- operator, in Boolean full-text searches, 139

& bit operator, 82, 510

&&, AND logical operator, 68, 499

!=, <> comparison operator, 70, 503

!, NOT logical operator, 68, 500

# (hash), for comments, 310

% wildcard

LIKE clause with, 74–75

in SELECT statement, 16–17

* (wildcard)

in Boolean full-text searches, 137

in SELECT statement, 14

@ (at sign), for MySQL variable, 99

\ (backslash), for directory, vs. escape character, 305

_ (wildcard), LIKE comparison operator with, 74–75

| bit operator, 82, 510

||, OR logical operator, 68, 500

~ operator, in Boolean full-text searches, 138–139

< comparison operator, 70, 137–138, 504

in Boolean full-text searches, 137–138

<< bit operator, 83, 510

<= comparison operator, 70, 505

<=> comparison operator, 70, 505– 506

= comparison operator, 70, 502–503

> comparison operator, 70, 504

in Boolean full-text searches, 137–138

>> bit operator, 83–84, 511

>= comparison operator, 70, 504–505

' (quotes), for string field, 12

" " operators, in Boolean full-text searches, 139–140

0 normal form, 226

1st normal form, 226–227

2nd normal form, 227–228

3rd normal form, 228–229

4th normal form, 233–234

5th normal form and beyond, 234– 236

50-percent threshold, 134

Boolean full-text searches and, 136