SQL – MySQL REPLACE() Function
The MySQL REPLACE() function replaces all case-sensitive occurrences of a substring within a string, with a new substring.
The MySQL REPLACE() function replaces all case-sensitive occurrences of a substring within a string, with a new substring.
The MySQL REVERSE() function reverses a string and returns the result.
The MySQL RIGHT() function extracts a number of characters from a string, starting from right.
The MySQL RPAD() function right-pads a string with another string, to achieve a specified length.
The MySQL SPACE() function returns a string of the specified number of space characters.
The MySQL SUBSTR() function extracts a substring from a string, starting from any position.
The MySQL SUBSTRING() function extracts a substring from a string, starting from any position.
The MySQL SUBSTRING_INDEX() function returns a substring of a string before a specified number of delimiter occurs.
The MySQL TRIM() function removes leading and trailing spaces from a string.