comparison functions

How Coalesce() Works in SQLite

May 28, 2020May 18, 2020 by Ian

In SQLite, the coalesce() function returns a copy of its first non-NULL argument, or NULL if all arguments are NULL.

It’s similar to the ifnull() function, except that coalesce() accepts more than two arguments (ifnull() only accepts two arguments).

SQLite Like() Function with Examples

May 28, 2020May 14, 2020 by Ian

The SQLite like() function enables you to compare a string against a given pattern. You can also specify an escape character if required.

You can use the like() function as an alternative to the LIKE operator (which enables you to run the Y LIKE X [ESCAPE Z] expression).

MIN() vs LEAST() in MySQL: What’s the Difference?

November 19, 2019July 16, 2018 by Ian

In MySQL, the difference between the MIN() and LEAST() functions is exactly the same as the difference between the MAX() and GREATEST() functions.

In each case, both functions perform a similar operation, but they do have a different syntax.

MAX() vs GREATEST() in MySQL: What’s the Difference?

November 19, 2019July 16, 2018 by Ian

At first glance, the MySQL MAX() and GREATEST() functions perform a similar operation. They both return the maximum value from a range of values. However, there’s a difference between these two functions.

The best way to see the difference between these two functions is to compare their syntax.

MySQL LEAST() Function – Find the Smallest Argument in a List of Arguments

November 19, 2019July 16, 2018 by Ian

The MySQL LEAST() function is a comparison function that returns the smallest value from a list of values.

The list of values is provided as multiple arguments. So in other words, LEAST() returns the minimum-valued argument from a list of arguments.

MySQL GREATEST() Function – Find the Largest Argument in a List of Arguments

November 19, 2019July 16, 2018 by Ian

The MySQL GREATEST() function is a comparison function that returns the largest value from a list of values.

The list of values is provided as multiple arguments. So in other words, GREATEST() returns the maximum-valued argument from a list of arguments.