How to Perform a Case-Sensitive LIKE Search in MySQL
The MySQL LIKE operator is commonly used to search for a specific pattern within a string. It is useful when you need to find values that begin with, end with, or contain a particular...
Tagged: SQL tutorial
How to Add Hours to Datetime in MySQL Using DATE_ADD()
Working with date and time values is an essential part of SQL development. Applications for sales, e-commerce, finance, logistics, customer support, scheduling, analytics, and SaaS frequently need to manipulate datetime values. One common requirement...
How to Add Days to a Date in MySQL Using DATE_ADD()
Add Days to a Date in MySQL, Date calculations are everywhere in data analysis. You may need to find a follow-up date, calculate a delivery deadline, create a trial expiration date, or simply determine...
MySQL Limit the Number of Characters Returned
MySQL Limit the Number of Characters Returned, you may sometimes need to truncate a string and return only a specific number of characters from a column. For example, suppose a table contains team names...
How to Remove the Time from a DATETIME Column
Remove the Time from a DATETIME Column, you will often encounter values stored as DATETIME, containing both a date and a time. For example: 2024-05-19 23:10:04 Sometimes, however, you only need the date portion:...
MySQL CASE Statement with NULL Values: How to Check for NULL in CASE
MySQL CASE Statement with NULL Values, when working with data in MySQL, you will often encounter NULL values. A NULL represents a missing, unknown, or unavailable value. If you need to handle these values...
How to Get the Last Day of the Previous Month in MySQL
Get the Last Day of the Previous Month in MySQL, Working with month-end dates is a common requirement in SQL. A report might need to compare this month’s sales with the previous month’s closing...
How to INNER JOIN on Multiple Columns in MySQL
mysql inner join multiple columns, sometimes one column isn’t enough to identify the relationship between two tables. Imagine a basketball database where the same team has a Guard, Forward, and Center. If you join...
How to Use INNER JOIN on Multiple Columns in MySQL
mysql inner join multiple columns, A SQL JOIN can look simple when two tables have one obvious column connecting them. But real-world databases are often more complicated. Sometimes a single column doesn’t provide enough...
How to Select the Last N Rows in MySQL
When working with MySQL databases, you may need to retrieve the last N rows from a table. This is a common requirement in data analysis, reporting, dashboards, application development, and database administration. For example,...