Are these queries Equivalent?

[richie]

Table:

---

A | C | E |

b | d | f |

b | j | f |

Query 1:

SELECT * FROM table_name WHERE A='b' || C='d' && E='f'

Query 2:

SELECT * FROM table_name WHERE A='b' && E='f' || C='d'

Does mysql have any kind of precedence when it comes to conditional selects? The two queries are the same, except that the conditions are shuffled around.

I tried the two queries, and they gave me the same two records.

I just want to be sure, before I incorporate the query into my app.

Thanks for any help.

Richie.

[pyfsapple]

There must have precedence, you may search from the documents of mysql or the database you use.

But adding of "()" pair must help!

e.g.

SELECT * FROM table_name WHERE (A='b' || C='d') && E='f'
--- "||" first and "&&" last.

and

SELECT * FROM table_name WHERE A='b' || (C='d' && E='f')
--- "&&" first and "||" last.

must be different!!

Have a nice day!