Category Archives: mysql

MySQL – Intersect Operator Table of content In mathematical set theory, the intersection of two sets is a set that contains only those elements that are common to both sets. In other words, the intersection of two sets is a set of elements that exist in both sets. If we perform the intersection operation on […]

MySQL – Between Operator Table of content MySQL Between Operator The BETWEEN operator in MySQL is a logical operator provided by SQL, that is used to restrict the range from which the data values are to be retrieved. The retrieved values can be integers, characters, or dates. You can use BETWEEN operator to replace a […]

MySQL – IS NULL Operator Table of content NULL values in a MySQL table fields indicate that no (or unknown) values are present in them. These values are different from zeroes or invalid values. In MySQL, it is not possible to check NULL values with comparison operators such as =, <, or <>. Instead, we […]