Why does mysql evaluate (TRUE or TRUE and FALSE) to true?

Question

Why does mysql evaluate (TRUE or TRUE and FALSE) to true?

If you type

SELECT (true or true and false)

in mysql it will return 1

which is true

. Why is this so? What is the order of evaluation in boolean expressions?

+3

sql mysql

Sequoia 15 oct. 14 at 14:57

source to share

1 answer

Mr. Llama · Accepted Answer · 2014-10-15T15:00:15+0000

According to the MySQL documentation on operator precedence , AND evaluates to OR.
This means your expression (true OR true AND false)

evaluates to (true OR (true AND false))

.

Why does mysql evaluate (TRUE or TRUE and FALSE) to true?

More articles: