Category Archives: mysql

MySQL – UNION vs UNION ALL Table of content UNION and UNION ALL operators in MySQL are used to retrieve the rows from multiple tables and return them as one single table. However, for these operators to work on these tables, they need to follow the conditions given below − The tables to be combined […]

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