To group data by commas (,) in the number field? For example, if the content is 12, there may be only 3 in the figure, and 1 in 123. Online seeking (table splitting and other storage methods are not considered for grouping)
To group data by commas (,) in the number field?
For example, if the content is 12, there may be only 3 in the figure, and 1 in 123. Online seeking (table splitting and other storage methods are not considered for grouping)
Reply content:
To group data by commas (,) in the number field?
For example, if the content is 12, there may be only 3 in the figure, and 1 in 123. Online seeking (table splitting and other storage methods are not considered for grouping)
MysqlThere is a function:Find_in_set. The usage is as follows:
Select id from table where FIND_IN_SET ('12', number );
In the above sentence, we can retrieve the ID set with number 12.
I read find_in_set upstairs, but I have never used it. I found this text and wrote it well:
Https://segmentfault.com/a/11...