mysql json数组取值、查询的问题

[cainiaoxxx]

数据表

id uid info
1 1001 {"name":"周年庆","status":0,"addtime":"2017-10-10"}
2 1002 [ {"name":"周年庆","status":0,"addtime":"2017-10-11"},{"name":"特价促销","status":0,"addtime":"2017-10-12"}]
3 1003 [ {"name":"特价促销","status":0,"addtime":"2017-10-12"},{"name":"国庆促销","status":0,"addtime":"2017-09-28"}]


对mysql如何筛选查询 数组里面的值
比如我想取得参加特价促销的用户数据，改怎么写查询语句

[cainiaoxxx]

有木有大神知道的啊

[zjcxc]

select * from tb
where info->'$.name' = '特价促销'  or JSON_CONTAINS(info->'$
.name', '"特价促销"', '$'
)

[cainiaoxxx]

引用 2 楼 zjcxc 的回复:

select * from tb
where info->'$.name' = '特价促销'  or JSON_CONTAINS(info->'$
.name', '"特价促销"', '$'
)

3Q