I write a lot of information which might be not useful for you so if you want a simple question this is my question : (i want to know is there anyway to use OR on SQL in other ways like this : WHERE …
Tag: logical-operators
What is Difference Between AND,OR operator in MYSQL ,While Retrieving the Rows?
Are there difference between these queries and how they execute? Answer It’s to do with intersecting truth tables. In the first query the or is inside brackets so it will execute first and return true if the country is either USA or France. Then the And will execute and compare the result of the OR to the result of creditlimit