Shulou(Shulou.com)06/01 Report--

Xiaobian to share with you mysql to remove a string of methods, I believe most people do not know how, so share this article for everyone's reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

mysql Methods to remove a string: 1. Intercept the string from the left, code is [left(str, length)];2. Intercept the string from the right, code is [right(str, length)];3. Intercept the string, code is [substring(str, pos)].

mysql to remove a string:

When using mysql, string truncation, character substitution, substring extraction, etc. are often performed. Details are as follows:

1. Intercept the string from the left

left(str, length) Description: left(truncated field, truncated length)

Example:

select left('charfunction', 5) as result from dual;

Output: charf

2. Intercept the string from the right

right(str, length) Description: right(truncated field, truncated length)

Example:

select right('charfunction',5) as result from dual;

Output: ction

3. Intercept the string, which is divided into two cases, namely interception from the beginning and interception from the middle.

substring(str, pos) Description: substring(truncated field, truncated from the first few bits)

substring(str, pos, length) substring(truncated field, truncated from which digit, truncated length)

Example:

select substring ('charfunction ', 5) as result from dual; output: functionselect substring ('charfunction', 5,5) as result from dual; output: uncti

(Note: If the digit number is negative, such as-5, it is the length from the last reciprocal digit to the end of the string or truncation)

4. Replace related characters

replace (str, old, new) Replace the old string in str with the new string

Example:

select replace ('charfunction ',' n','WW') as result from dual; Output: charfuWWctioWW Above is all the contents of mysql's method of removing a string. Thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.