MySQL row to column (split string scene)

One-to-many do not establish an intermediate table when often used in the form of delimiters to store "many" in the "one" of a field, the cost is not to a pair of times as directly associated with the query, generally used in the program after the separate query method. Such as:

How can you directly query the effect with SQL statements?

You can use an ordinal table in which there are no other fields in addition to successive IDs, and the value range of the ID depends on the amount of information stored in "One" after the split.

Implementing SQL:

Selectname,replace (Substring_index (Mobile, ', ', a.id), CONCAT (Substring_index (Mobile, ', ', a.id-1), ', ') as Mobilefromsquence ACROSS JOIN (Selectname,concat (Mobile, ', ') as Mobile,length (mobile)-LENGTH (REPLACE ("Mobile, ', ', ') ) + 1 as sizefrom ' user ') b on a.ID <= b.size

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

MySQL row to column (split string scene)