Home > database >  Mysql, seek common set of data.
Mysql, seek common set of data.

Time:09-27

The data is as follows:
(" a ", "b; C)

(" b ", "a; d; E ")

(" e ", "b; C)

(" c ", "a; b; F ")

(" f ", "c; g; E ")

(" d ", "j; k; L ")
Said the ABC is a reference to the BC kin data, quotes ade b at the same time, then abcde is group data

The above data, is a group of data

Finally, is each member data, corresponding kin, that is, the output is two columns



CodePudding user response:

.