In MariaDB, SPACE() is a built-in string function that returns a given number of space characters.
You provide the number of spaces to return when you call the function.
Continue readingCategory: DBMS
Database Management Systems
How SOUNDS LIKE Works in MariaDB
In MariaDB, you can use SOUNDS LIKE in a query to match words that sound alike.
How SOUNDEX() Works in MariaDB
In MariaDB, SOUNDEX() is a built-in string function that returns the Soundex string from a given string.
Soundex is a phonetic algorithm for indexing names by sound, as pronounced in English. If two words sound the same, they should have the same Soundex string. If two words sound similar, but not exactly the same, their Soundex string might look similar but not exactly the same.
The function accepts one argument: the string for which to return the Soundex string from.
Continue readingHow REVERSE() Works in MariaDB
In MariaDB, REVERSE() is a built-in string function that returns a string with the characters in reverse order.
The function accepts one argument: the string to reverse.
Continue readingHow REPLACE() Works in MariaDB
In MariaDB, REPLACE() is a built-in string function that allows you to replace a part of a string with another string.
The function accepts three arguments: the string, the substring to replace, and the string to replace the substring with.
Continue reading3 Ways to Return Distinct Values in MongoDB
Distinct values are those values with redundant duplicates removed. In other words, distinct values are unique values.
In MongoDB there are a few ways we can return distinct values in a query. This article presents 3 ways to return distinct values in the mongo shell.
Continue readingHow POSITION() Works in MariaDB
In MariaDB, POSITION() is a built-in string function that returns the position of the first occurrence of a substring within another string. It’s part of ODBC 3.0.
POSITION(substr IN str) is a synonym for LOCATE(substr,str).
POSITION() is also similar to the INSTR() function, except that POSITION() uses the IN syntax, and that the argument order is reversed between these two functions.
How SUBSTRING_INDEX() Works in MariaDB
In MariaDB, SUBSTRING_INDEX() is a built-in string function. It returns a substring from a string before a certain number of occurrences of the specified delimiter.
SUBSTRING_INDEX() requires at three arguments; the string, the delimiter, and the count (i.e. number of occurrences of that delimiter).
Change the Password for a SQL Server Login
This article demonstrates how to use T-SQL to change the password for a SQL Server login.
You can change the password for another login (assuming you have the appropriate permissions), or you can change it for your own login. This article outlines both of these scenarios.
Continue readingHow REPEAT() Works in MariaDB
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.
Continue reading