mysql 大字段拆分原因_MYSQL字段拆分问题

最新推荐文章于 2021-12-02 17:40:17 发布

weixin_39986466

最新推荐文章于 2021-12-02 17:40:17 发布

阅读量360

点赞数

文章标签： mysql 大字段拆分原因

本文链接：https://blog.csdn.net/weixin_39986466/article/details/113277171

版权

select SUBSTRING_INDEX(REPLACE(t,CONCAT(SUBSTRING_INDEX(t, '"week":', rowNo),'"week":"'),''),'"',1) as t from

(

SELECT a.*,(@rowNum:=@rowNum+1) as rowNo,length(t) - length( REPLACE(t,'},{','}{')) as num

from

(

select

'[{"startDate":"08:45","endDate":"17:45","week":"1"},{"startDate":"08:45","endDate":"17:45","week":"2"},{"startDate":"08:45","endDate":"17:45","week":"3"},{"startDate":"08:45","endDate":"17:45","week":"4"},{"startDate":"08:45","endDate":"17:45","week":"5"}]'

as t

)a JOIN(

select * from `table`,(Select (@rowNum :=0)) c

)b on 1=1

)x where rowNo<=num`table` 这个表可以随便一张数据库存在的表并且条数要大于或等于num