MySQL NULL Values
We have seen the SQL SELECT command along with the WHERE caluse to fetch data from a MySQL table, but when we try to give a condition, which compares the field or column value...
Category: Mysql
MySQL LIMIT
The MySQL LIMIT clause is used to narrow or limit, a result set to the specified number of rows. The LIMIT clause accepts one or two arguments, one is offset and another one is...
MySQL LIKE
The comparison operators discussed so far have compared one value, exactly to one other value. Such precision may not always be desired or necessary. For this purpose MySQL provides the LIKE. The LIKE allows...
MySQL Between Operator
In order to select data that is within a range of values, the BETWEEN operator is used. The BETWEEN operator allows the selection of rows that contain values with a specified lower and upper...
MySQL Order By
The data return by a SELECT query can be sorted into a specified order using ORDER BY clause. Syntax: SELECT column-name FROM table-name ORDER BY column-name; When the ORDER BY keywords are followed by...
MySQL AND, OR, IN, NOT IN
AND, OR, In, NOT In these all are called logical operators: AND(&&) : The AND operator allows creating an SQL statement based on two or more conditions being met. It can be used in...
MySQL Where Clause
A WHERE Clause is an SQL query to apply a filter on the rows retrieved. When a WHERE Clause is added to MySQL query, the MySQL engine compares each record in the table with...
MySQL SELECT DISTINCT
A table could hold duplicate rows. In such a case, to view only unique rows the distinct clause can be used. The DISTINCT clause allows removing duplicates from the result set. The DISTINCT clause can...
