MySQL Crash Course

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

WHERE claues

     combining AND/OR 2nd

WHERE clause

     filtering groups

WHERE clauses

     checking against single values 2nd

     checking for nonmatches 2nd

    combining

         with AND 2nd

         with OR 2nd

     combining queries. [See also compound queries]

     compared to UNION

     dates, filtering by 2nd

     importance of in joins 2nd

     IN, utilizing 2nd

    NOT

         utilizing 2nd

    NULL values

         checking for 2nd

    operators

         list of 2nd

     overview 2nd

    parentheses

         utilizing

     quotes, utilizing

     range values, checking 2nd

white space

     in statements

whitespace metacharacters (regular expressions) 2nd

wildcard operators

     limitations of 2nd

wildcards

     guidelines for 2nd

    LIKE operator

         compared to REGEXP 2nd

         overview

     NULL interaction

     overview 2nd

    percent signs

         overview 2nd

     trailing spaces, dangers of

    underscores

         overview 2nd

WITH ROLLUP

     utilizing