Home > Database > Mysql Tutorial > body text

What are the methods for implementing string interception in MySQL?

WBOY
Release: 2023-06-03 10:54:20
forward
15946 people have browsed it

Preface

It is common to deal with the database during the back-end development process. Sometimes you will encounter only a part of a certain piece of data in the database. In this case, there are two ways:

(1) Read it out and then process it accordingly

(2) Use the functions that come with MySQL for processing when reading

Next we will use the second There are three ways to summarize columns

(1) Create a user table as follows:

What are the methods for implementing string interception in MySQL?

The LEFT(col_name, length) function: extracts from left to right. col_name is the column name (required), length is the length taken from left to right (required to be a positive integer, if it is a negative number, nothing is returned, the subscript starts from 1, not 0)

A : length: integer

What are the methods for implementing string interception in MySQL?

B: length: negative number

What are the methods for implementing string interception in MySQL?

##The function right(col_name, length) extracts characters from the right-hand side of the string. col_name is the column name (required), length is the length taken from right to left (must be a positive integer, if it is a negative number, nothing is returned. The subscript starts from 1, not 0)

A: length : Integer

What are the methods for implementing string interception in MySQL?

B: length: Negative number

What are the methods for implementing string interception in MySQL?## (4) substring(col_name, start, length) function: col_name column name (required), start from which number (required to be an integer starting from 1), length truncation length (optional, positive integer)

A: start: positive integer, length If not selected, counting from left to right, starting from the third character and cutting to the right until the end.

What are the methods for implementing string interception in MySQL?B: start: negative integer, length is not selected, counting from the right to the left, starting from the third character and intercepting it to the right until the end.

What are the methods for implementing string interception in MySQL?C: start: positive integer, length: positive integer; counting from left to right, 5 characters are intercepted from the third character to the right.

What are the methods for implementing string interception in MySQL?D: start: negative integer, length: positive integer; counting from the right to the left, starting from the third character, 3 characters are intercepted to the right.

What are the methods for implementing string interception in MySQL?E: When intercepting from star and the number of characters immediately following it

What are the methods for implementing string interception in MySQL?F: start: negative integer, length: negative integer; nothing is intercepted

What are the methods for implementing string interception in MySQL? (5) substring_index(col, a, num) function: from the Use num a's to divide col. When num is a positive integer, it is divided from left to right and taken from left to right; when num is a negative integer, it is divided from right to left and taken from right to left.

A: Split by the first "o" of hello world (after splitting: hell oworld)

What are the methods for implementing string interception in MySQL?B: Split by the first "o" of hello world The second ‘o’ is used for segmentation (after segmentation: hello w orld)

What are the methods for implementing string interception in MySQL?C: Counting from right to left, use the first ‘o’ Split (after splitting: hello wo rld)

What are the methods for implementing string interception in MySQL?D: Counting from right to left, split with the second ‘o’ (after splitting: hello world)

What are the methods for implementing string interception in MySQL?Attachment: Detailed explanation of functions related to mysql string interception

1. SUBSTRING_INDEX(subStr, matchStr, index)

Start intercepting the string based on the matching characters and their occurrence positions

    subStr: Fields to be intercepted
  • matchStr: Matching characters
  • index: Starting from the matching character, if it is a positive number, search from the left and intercept to the left; if it is a negative number, search from the right and intercept to the right

2. LEFT(subStr,index)

Start from the left and intercept it to the right, ending at the index position (index starts from 1)

  • subStr: The field that needs to be intercepted

  • index: The position to stop interception (including the characters at this position)

3. RIGHT(subStr,index)

Start from the right and intercept to the left, ending at the index position from the right (index starts from 1)

  • subStr: The field that needs to be intercepted

  • index: The position to stop interception (including the characters at this position)

4, SUBSTRING( subStr, index)

When index is a negative number, start from the right and intercept to the left, up to the index position from the right

When index is a positive number, start from the left Intercept to the right, up to the index position from the left

  • subStr: The field to be intercepted

  • index: The position to stop interception (including characters at this position)

The above is the detailed content of What are the methods for implementing string interception in MySQL?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:yisu.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template