Category Archives: mysql

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 […]

MySQL – IS NOT NULL Operator Table of content A NULL value in a MySQL table indicates a missing or unknown value. It appears to be blank and does not contain any data. This is different from zero values. It is very important to understand that a NULL value is different than a zero value […]