Here are four options for returning rows that contain uppercase characters in MariaDB.
MariaDB
How IFNULL() Works in MariaDB
In MariaDB, the IFNULL() function allows us to replace NULL values with another value.
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.
How to Get the End of the Month in MariaDB
In MariaDB, we can use the LAST_DAY() function to return the last day of a given month.
This could be the last day of the current month, or the last day of the month based on a date that we specify.
2 Ways to Return Rows that Only Contain Non-Alphanumeric Characters in MariaDB
Below are two methods for returning rows that contain only non-alphanumeric characters in MariaDB.
Non-alphanumeric characters include punctuation characters like !@#&()–[{}]:;',?/* and symbols like `~$^+=<>“, as well as whitespace characters like the space or tab characters.
Return the Number of Days in a Month in MariaDB
Here’s a nifty trick we can use in MariaDB to return the number of days in a month based on a given date.
How to Detect if a Value Contains at Least One Numerical Digit in MariaDB
When working with MariaDB, you may occasionally find yourself needing to return all rows that contain at least one numerical digit.
In such cases, you may find the following example useful.
Fix “ERROR 1136 (21S01): Column count doesn’t match value count at row 1” when Inserting Data in MariaDB
If you find yourself getting an error that reads something like “ERROR 1136 (21S01): Column count doesn’t match value count at row” in MariaDB, it’s probably because you’ve specified the wrong number of expressions for the number of columns in the column when attempting to insert data into a table.
In other words, you’re trying to insert too many columns or not enough columns.