MySQL

In this tutorial, we will learn about the MySQL LIKE Operator. Suppose you are going through a record of names and you want to find out names beginning with ‘P’. Furthermore, what if you want to find names that end with ‘r’. For these purposes, MySQL provides us with the LIKE Operator. The MySQL LIKE …

MySQL LIKE Operator – Partial Matching Conditional Queries Read More »

In this tutorial, we will learn about the MySQL NOT BETWEEN operator. In the MySQL BETWEEN operator article, we saw how we can return records within a range. It also helped us avoid conditions with the AND operator and making our code more readable and effective.  MySQL NOT BETWEEN is a combination of two operators …

MySQL NOT BETWEEN Operator Read More »

In this tutorial, we’ll learn about MySQL BETWEEN operator. Suppose you are a school teacher and you want to find out the students who scored marks between 60 and 80 in Science. You could make use of the comparison operators along with the AND operator but a more effective way is using the MySQL BETWEEN …

MySQL BETWEEN Operator Read More »

In this tutorial, we will learn about the MySQL ORDER BY clause. Ordering and sorting as a feature in tables and databases are very important. This helps you analyze information and provide you with valuable insights into it. You could be the CEO of the company and sort the profit of every product you sell …

MySQL ORDER BY Clause – How to Sort Records In A Table? Read More »

In this tutorial, we will take a look at the MySQL IS NOT NULL condition. IS NOT NULL condition is the exact opposite of the IS NULL condition. IS NOT NULL filters through the table for a column and returns only those records who do not have a NULL value in that particular column. This …

MySQL IS NOT NULL Condition – Finding non-NULL values in a column Read More »

In this tutorial, we will take a look at the MySQL IS NULL condition. Suppose you are conducting a survey in your neighborhood and you hand out a small questionnaire to everyone in the area. After a day or two, you receive the questionnaires back and you notice that some people have not answered a …

MySQL IS NULL Condition – How-to Find And Replace NULL Vales in a Database? Read More »

In this quick tutorial, we’ll take a look at the MySQL NOT operator. Suppose you are a teacher and you want a list of students who were not present for all 100 days in a term. In other words, the condition of students present for 100 days should NOT be satisfied, and the resulting output …

MySQL NOT Operator Read More »

In this tutorial, we’ll be talking about the MySQL AND Operator. Suppose you are playing a video game and you pass a level only if you earn $50,000 and complete 2 missions. So, the logic is that you have two conditions you need to satisfy to pass the level. What if you encounter a similar …

MySQL AND Operator – Execute Multiple Conditions in MySQL Read More »