Category Archives: mysql

MySQL – LIKE Operator Table of content MySQL LIKE Operator The LIKE Operator in MySQL database is a logical operator that is used to retrieve the data from a table, based on a specified pattern. To filter and search for some records in a table, in a very basic way is using a WHERE clause. […]

MySQL – IN Operator Table of content MySQL In Operator The IN operator in MySQL is a logical operator that allows us to check whether the values in a database are present in a list of values specified in the SQL statement. The IN operator can be used with any data type in SQL. It […]

MySQL – OR Operator Table of content MySQL OR Operator MySQL does not have a built-in Boolean data type. Instead, Boolean values are represented using numeric data types, where zero is used as false and any non-zero value is used as true. The MySQL OR operator is a logical operator that combines two or more […]