MySQL – Exists Operator Table of content MySQL Exists Operator The EXISTS operator in MySQL checks for the existence of a record in a table. It”s used in the WHERE clause of a SELECT statement to verify if a subquery returns any rows. It returns TRUE if the subquery returns at least one record, else […]
Category Archives: mysql
MySQL – NOT EQUAL Operator Table of content MySQL NOT EQUAL Operator The MySQL NOT EQUAL operator is used to compare two values and return true if they are not equal. It is represented by “<>” and “!=”. The difference between these two is that <> follows the ISO standard, but != doesn”t. So, it […]
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 […]