In MariaDB, REPEAT() is a built-in string function that returns a string repeated a certain number of times.
You pass the string, as well as the number of times you want it repeated when you call the function.
what is
How QUOTE() Works in MariaDB
In MariaDB, QUOTE() is a built-in string function that allows you to escape a string so that it’s suitable for inclusion in an SQL statement.
The string is returned enclosed by single quotes, and a backslash is prepended to each instance of single quote ('), backslash (\), ASCII NUL, and Control-Z characters.
How MID() Works in MariaDB
In MariaDB, MID() is a synonym for SUBSTRING(). It returns a substring from a given string.
According to the MariaDB documentation it’s a synonym for the SUBSTRING(str,pos,len) syntax of SUBSTRING(), however, my tests show that it works with all of the various forms.
MariaDB SUBSTR() Explained
In MariaDB, SUBSTR() is a synonym for SUBSTRING().
It’s a built-in string function that returns a substring from a given string.
It requires at least two arguments; the string, and the position for which to extract the substring from. It also accepts an optional third argument that allows you to specify how long the substring should be.
How SUBSTRING() Works in MariaDB
In MariaDB, SUBSTRING() is a built-in string function that returns a substring from a given string.
SUBSTRING() requires at least two arguments; the string, and the position for which to extract the substring from. It also accepts an optional third argument that allows you to specify how long the substring should be.
How MATCH AGAINST Works in MariaDB
In MariaDB, MATCH AGAINST is a special construct used to perform a full-text search on a full-text index.
How COERCIBILITY() Works in MariaDB
In MariaDB, COERCIBILITY() is a system function that returns the collation coercibility value of its string argument.
It defines how collations will be converted in the case of collation conflict. In such conflicts, an expression with a higher coercibility is converted to the collation of an expression with a lower coercibility.
How MAKE_SET() Works in MariaDB
In MariaDB, MAKE_SET() is a string function that returns a set value, based on the values provided in its arguments.
A set is a string containing substrings separated by comma (,) characters.
How TRIM_ORACLE() Works in MariaDB
In MariaDB, TRIM_ORACLE() is a synonym for the Oracle mode version of the TRIM() function.
TRIM_ORACLE() is available in all modes, so it saves you from having to switch to Oracle mode, which is what you’d need to do if you wanted the TRIM() function to behave like Oracle’s TRIM() function.
The difference is in how each function treats empty strings. Oracle returns null whereas MariaDB returns an empty string.
How LTRIM_ORACLE() Works in MariaDB
In MariaDB, LTRIM_ORACLE() is a synonym for the Oracle mode version of the LTRIM() function.
LTRIM_ORACLE() is available in all modes, so it saves you from having to switch to Oracle mode, which is what you’d need to do if you wanted the LTRIM() function to behave like Oracle’s LTRIM() function.
The difference is in how each function treats empty strings. Oracle returns null whereas MariaDB returns an empty string.