· 6 years ago · Jun 20, 2019, 11:24 AM
1SET @myjson = '["gmail.com","mail.ru","arcor.de","gmx.de","t-online.de",
2 "web.de","googlemail.com","freenet.de","yahoo.de","gmx.net",
3 "me.com","bluewin.ch","hotmail.com","hotmail.de","live.de",
4 "icloud.com","hotmail.co.uk","yahoo.co.jp","yandex.ru"]';
5SELECT JSON_LENGTH(@myjson);
6-- result: 19
7SELECT JSON_VALUE(@myjson, '$[0]');
8-- result: gmail.com
9
10SET @c = 'xxx,yyy,zzz';
11SELECT * from countries
12WHERE FIND_IN_SET(countryname,@c);