- MySQL Between
The BETWEEN is used in the WHERE clause to check if a value is in a range. Here is an example of BETWEEN and AND. We are querying customers that have sales rep with id between 1 and 7. BETWEEN can also be done by using >= and <=. Here is an example of […]
- MySQL ISNULL
IS NULL is used in the WHERE clause to check if a value is NULL or not. IS NULL in action.
- MySQL Limit
The LIMIT clause, as you might guess, is used to limit the number of rows returned in the result set. It has two parameters or arguments. The first parameter is offset which tells mysql how many rows to skip before starting to retrieve. The second parameter is count which tells mysql how many rows…
- MySQL Like
The LIKE operator is used to check if a string contains another string. These two wildcards are used with LIKE:1. “%” – check for a match of one or more characters2. “_” – check for a match of a single character If you are searching for something that ends with a certain pattern of […]
- MySQL Where
The WHERE clause is used in a SELECT statement with conditions to filter the result set. It is also used in the UPDATE and DELETE statement. There can be one or many conditions and a condition must be evaluated to true or false. A row must satisfy all conditions to be included in the […]