Here are four options for returning rows that contain uppercase characters in MariaDB.
Relational
MySQL IFNULL() Explained
MySQL has an IFNULL() function that allows us to easily replace NULL values with another value.
MySQL ISNULL() Explained
In MySQL, the ISNULL() function enables us to check whether a value is null or not. If it’s null, then 1 is returned, otherwise 0 is returned.
2 Ways to Return Non-Numeric Values in SQLite
The following SQLite examples return only those rows that have non-numeric values in a given column.
How IFNULL() Works in MariaDB
In MariaDB, the IFNULL() function allows us to replace NULL values with another value.
MySQL IF() Function Explained
MySQL has an IF() function that provides a convenient way to perform a simple “IF/ELSE” operation.
It works similar to a basic IF/ELSE statement, in that it allows us to check for a condition, and return a different result depending on whether it’s true or not.
More specifically, if the first argument to the IF() function is true, the second argument is returned. If it’s not true, the third argument is returned.
How COALESCE() Works in MariaDB
In MariaDB, the COALESCE() operator returns the first non-NULL value in the list, or NULL if there are no non-NULL values.
MySQL NULLIF() Explained
In MySQL, NULLIF() is a flow control function that returns NULL if both of its arguments are equivalent. Otherwise it returns the first argument.