Linux Today: Linux News On Internet Time.

How Operator Precedence Affects MySQL SELECT Queries

Sep 22, 2010, 17:33 (0 Talkback[s])
(Other stories by Rob Gravelle)

"When joining tables on common fields, if you're not diligent in the use of AND-OR combinations in the criteria clause, be prepared for unexpected results! Learn how to break filtering criteria into individual steps and how to group AND-OR statements to most effectively isolate the data that you wish to retrieve.

"The following code can be used to create and populate the employees and shops tables. If you've downloaded the table data from my recent articles, you don't need these as they are the same:"

Complete Story

Related Stories: