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

This article mainly introduces the method of splitting the string into multiple lines by mysql, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Mysql's method of splitting a string into multiple lines: you can use the SUBSTRING_INDEX () function to split it, for example, [substring_index (a. Chaingrad.

This can be achieved by using the string interception function SUBSTRING_INDEX.

Syntax:

SUBSTRING_INDEX (str, delimiter, count)

Description:

Returns a substring of str, intercepted at the location where the count occurs in delimiter. If count > 0, count from the left and return the substring before the position; if count < 0, count from the right and return the substring after the position.

Delimiter is case-sensitive and multibyte secure.

For example:

SELECT substring_index (substring_index (a. Chaingraders). Helpfulness topicmakers id + 1),'_',-1) AS IDFROM (select'1, 11, 1223, 1242'as chain) a JOIN mysql.help_topic b ON b.help_topic_id

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.