表

id?????????uid?????????????????????info

1????????1001?????????{"name":"周年慶","status":0,"addtime":"2017-10-10"}

2????????1002?????????[?{"name":"周年慶","status":0,"addtime":"2017-10-11"},{"name":"特價(jià)促銷","status":0,"addtime":"2017-10-12"}]

3????????1003?????????[?{"name":"特價(jià)促銷","status":0,"addtime":"2017-10-12"},{"name":"國慶促銷","status":0,"addtime":"2017-09-28"}]

查詢語句：select?*?from?tb

where?info->'$.name'?=?'特價(jià)促銷'??or?JSON_CONTAINS(info->'$[*].name',?'"特價(jià)促銷"',?'$')

查詢語句：SELECT * FROM nlu_define_table WHERE

JSON_CONTAINS(JSON_ARRAY("我","想","銷","存單"),keywords->'$.keywords') ORDER BY weights DESC;

其他查詢語句：

SELECT * FROM nlu_define_table;

SELECT * FROM nlu_define_table WHERE

keywords LIKE "%銷%";

SELECT * FROM nlu_define_table WHERE

JSON_EXTRACT(keywords,'$.keywords') LIKE "%銷%";

SELECT * FROM nlu_define_table WHERE

keywords -> '$.keywords' LIKE "%銷%";

第三條sql和第四條sql是等效。

MyBatis

select

*

from nlu_define_table

where 1 = 1

AND

'$[*].name', ]]>'"${name}"'