SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table test ( test_column varchar(500) ); insert into test (test_column) values ('test1:false:String,test2:false:String,test3:false:String,test4:false:String,test5:false:String,test1:false:String,test2:false:String,test3:false:String,test4:false:String,test5:false:String,') ; select test_column from test; select j.name from test t join json_table( replace(json_array(test_column), ',', '","'), '$[*]' columns (name varchar(50) path '$') ) j ;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear