MySQL SQLLesson 10Free preview
MySQL OR
This lesson is part of MySQL · All levels
Summary
OR operators are used when a line satisfies one of several conditions to participate in display. OR makes the result wider than AND, so it's often combined with parentheses to make the logic out of order. In MySQL, the symbolic OR matching is two pipeline markings, but it is still recommended to use the OR keyword for more readability.
Key points
- OR returns TRUE when at least one condition is true
- OR expands the filter output because the conditions are more loose
- Use parentheses when mixing OR with AND to evaluate as expected
- The symbolic OR field in MySQL is a
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.