MySQL intercepts the sql statement of the string function

1. left(name,4) intercepts the 4 characters on the left

List:

SELECT LEFT(201809,4) 年

Results: 2018

2. right (name, 2) intercepts the 2 characters on the right

SELECT RIGHT(201809,2) 月份

Result: 09

3. SUBSTRING(name,5,3) intercepts the name field starting from the fifth character and only intercepts the next 3 characters

SELECT SUBSTRING('成都融資事業部',5,3)

Results: Division

4. SUBSTRING(name,3) intercepts the name field starting from the third character and all subsequent characters

SELECT SUBSTRING('成都融資事業部',3)

Results: Financing Division

5. SUBSTRING(name, -4) starts from the 4th character position (counting down) of the name field and continues until the end

SELECT SUBSTRING('成都融資事業部',-4)

Result: Investment Division

6. SUBSTRING(name, -4, 2) starts from the 4th character position (countdown) of the name field and only takes the next 2 characters.

SELECT SUBSTRING('成都融資事業部',-4,2)

Results:

Note: We noticed that in the function substring(str,pos,len), pos can be negative, but len ​​cannot be negative.

7. substring_index('www.baidu.com', '.', 2) intercepts all characters before the second '.'

SELECT substring_index('www.baidu.com', '.', 2)

Results: www.baidu

8. substring_index('www.baidu.com', '.', -2) intercepts all characters after the second '.' (counting down)

SELECT substring_index('www.baidu.com', '.', -2)

Result: baidu.com

9. SUBSTR(name, 1, CHAR_LENGTH(name)-3) intercepts the name field and removes all characters except the last three digits of the name field

SELECT SUBSTR('成都融資事業部', 1, CHAR_LENGTH('成都融資事業部')-3)

Result: Chengdu Financing

Summarize

The above is the MySQL SQL statement for intercepting string functions introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!