Database

This article will be looking into how to SELECT the last record of a MySQL table. We will be going through a few examples to demonstrate the concept. Table of Contents MySQL select last record of table using LIMIT MySQL select last record of table using MAX() function Let us get started by making the sample data […]

This article will be looking into how to use BETWEEN operator with dates in MySQL select where statements. We will be going through a few examples to demonstrate the concept. Table of Contents: Select data between two dates in MySQL MySQL select data between two today and 7 days MySQL select where date between two

This article will be looking into how to use greater than operator with a date. We will be going through a few examples to demonstrate the concept. Table of Contents: MySQL where date greater than today MySQL where date greater than yesterday MySQL where date greater than 7 days MySQL where date greater than 30

This article will be looking into MySQL SELECT WHERE statements with yesterday’s date in the WHERE clause. We will be going through examples to illustrate its working. Table of Contents: MySQL Select Yesterday’s Date MySQL Select Where Date is Yesterday using CURRENT_DATE() or SUBDATE() Let us get started by making the sample data. Create a table named user_login_details,

In this article, we will be looking into MySQL select where the date is today’s date. We will be going through examples to illustrate its working. Let us get started by making the sample data. Create a table named user_login_details, followed by inserting some rows into it. Let us have a view of the table user_login_details

In this article, we will be discussing MySQL SELECT WHERE statements with MONTH and YEAR conditions. We will be going through various examples to illustrate the same. Table of Contents:- MySQL Select Where Month and Year Syntax MySQL Select Where Month and Year Condition Examples Comparing Dates by Month and Year in MySQL Select MySQL

In this article, we will be discussing MySQL SELECT WHERE statement when column value is NULL. While working with strings, we mostly think that NULL is the same as an empty string(‘ ‘), but that is not a valid statement to make. In MySQL, NULL’s concept is different. When NULL is compared to any value,

This article will be going through a few examples to illustrate MySQL SELECT WHERE with NOT IN clause. Table of Contents:- Syntax MySQL SELECT WHERE NOT IN LIST MySQL SELECT WHERE NOT IN SUBQUERY MySQL SELECT WHERE NOT IN ANOTHER TABLE Let us get started by making the sample data used across the examples. We will be creating two

In this article, we will go through various examples of MySQL SELECT WHERE with the LIKE clause. LIKE is generally used in the SELECT statements when the user does not have the string’s full details and when the user wants similar results with a specified pattern. We will be discussing the usage of characters (%)

This article will discuss how to use the SELECT WHERE IN statement along with a related sub-query. Subqueries are SELECT statements within another statement.  SELECT WHERE IN subquery is generally used when the sub-query results are interlinked to the primary/ outer query results. The final result depends on the relationship of the output of the inner query