KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a written a mysql select query to fetch schedule details based on origin states,origin city,destination state and destination city. In my query i have used AND and OR operator. Here is my query, SELECT * FROM TruckLoadSchedule ts WHERE ts.originState IN (states) AND ts.originCity IN (cities) OR ts.destState IN (states) AND ts.destCity IN (cities); But I need to know the priority of AND and OR operator in the above query, i mean to say will it do something like this (X AND Y) OR (M AND Q) internally?
Tags (comma-separated)
Save Edits
Cancel