In MariaDB, the NOT LIKE operator is used to test whether or not a string does not match a pattern. It returns the inverse of the LIKE operator. It’s the same as applying the NOT operator against the whole LIKE expression.
Category: Relational
How RIGHT() Works in MariaDB
In MariaDB, RIGHT() is a built-in string function that returns a given number of characters from the rightmost part of a string.
RIGHT() accepts two arguments; the string, and the number of characters to return from the right part of that string.
MariaDB UCASE() Explained
In MariaDB, UCASE() is a built-in string function that returns its string argument with all characters changed to uppercase.
The result is returned in the current character set mapping. The default is latin1 (cp1252 West European).
UCASE() is a synonym for UPPER().
How UPPER() Works in MariaDB
In MariaDB, UPPER() is a built-in string function that returns its string argument with all characters changed to uppercase.
The result is returned in the current character set mapping. The default is latin1 (cp1252 West European).
Another MariaDB function, UCASE() is a synonym for UPPER().
MariaDB LCASE() Explained
In MariaDB, LCASE() is a built-in string function that returns its string argument with all characters changed to lowercase.
The result is returned in the current character set mapping. The default is latin1 (cp1252 West European).
LCASE() is a synonym for LOWER().
How to Truncate Text with an Ellipsis in MariaDB
Sometimes you might find that the amount of text returned in a database column is too long. You might just want to return a short snippet of that text, followed by an ellipsis or three dots.
Fortunately, this is relatively easy to do in MariaDB.
Continue readingHow LEFT() Works in MariaDB
In MariaDB, LEFT() is a built-in string function that returns a given number of characters from the leftmost part of a string.
LEFT() accepts two arguments; the string, and the number of characters to return from the left part of that string.
How LOWER() Works in MariaDB
In MariaDB, LOWER() is a built-in string function that returns its string argument with all characters changed to lowercase.
The result is returned in the current character set mapping. The default is latin1 (cp1252 West European).
Another MariaDB function, LCASE() is a synonym for LOWER().
How LOCATE() Works in MariaDB
In MariaDB, LOCATE() is a built-in string function that returns the position of the first occurrence of a substring within another string.
LOCATE() is similar to the INSTR() function, except that LOCATE() provides the option of specifying a starting position for the search. Also, the argument order is reversed between these two functions.
How INSTR() Works in MariaDB
In MariaDB, INSTR() is a built-in string function that returns the position of the first occurrence of a substring within another string.
INSTR() is similar to the LOCATE() function, except that LOCATE() provides the option of specifying a starting position for the search. Also, the argument order is reversed between these two functions.