MySQL Simple details

1. The WHERE clause with and and or precedence is and high, and any WHERE clause that uses and and or operations should use parentheses to explicitly group the operators.
2. Between operations include boundaries.
3. The in operator accomplishes the same work as multiple or operators.
4. The NOT keyword can negate the in,between,exists clause.
5. Wildcard characters are powerful and expensive. In the where statement is generally not written in front. (Simple search criteria written in front of the search efficiency is high)

MySQL Simple details