a:1:{i:0;a:11:{i:0;a:2:{s:8:"sphinxql";s:209:"INSERT INTO rt1 (id, title, j) VALUES (1, 'do it test blue', '{"price":[11,15], "doc":"manticore is very good"}' ), (2, 'tests of the best', '{"doc":"core of reactor"}' ), (3, 'the wild west', '{"price":11}' )";s:14:"total_affected";i:3;}i:1;a:3:{s:8:"sphinxql";s:20:"SELECT * FROM test_d";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:4:{s:2:"id";s:1:"1";s:3:"idd";s:1:"0";s:5:"title";s:15:"do it test blue";s:1:"j";s:48:"{"price":[11,15],"doc":"manticore is very good"}";}i:1;a:4:{s:2:"id";s:1:"2";s:3:"idd";s:1:"0";s:5:"title";s:17:"tests of the best";s:1:"j";s:25:"{"doc":"core of reactor"}";}i:2;a:4:{s:2:"id";s:1:"3";s:3:"idd";s:1:"0";s:5:"title";s:13:"the wild west";s:1:"j";s:12:"{"price":11}";}}}i:2;a:3:{s:8:"sphinxql";s:64:"SELECT id, REGEX(title, 'est') as c, title, j FROM rt1 WHERE c>0";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:4:{s:2:"id";s:1:"1";s:1:"c";s:1:"1";s:5:"title";s:15:"do it test blue";s:1:"j";s:48:"{"price":[11,15],"doc":"manticore is very good"}";}i:1;a:4:{s:2:"id";s:1:"2";s:1:"c";s:1:"1";s:5:"title";s:17:"tests of the best";s:1:"j";s:25:"{"doc":"core of reactor"}";}i:2;a:4:{s:2:"id";s:1:"3";s:1:"c";s:1:"1";s:5:"title";s:13:"the wild west";s:1:"j";s:12:"{"price":11}";}}}i:3;a:3:{s:8:"sphinxql";s:58:"SELECT id, title, j FROM rt1 WHERE REGEX(title, '\\bwest')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"3";s:5:"title";s:13:"the wild west";s:1:"j";s:12:"{"price":11}";}}}i:4;a:3:{s:8:"sphinxql";s:59:"SELECT id, title, j FROM test_d WHERE REGEX(j.doc, '^core')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"2";s:5:"title";s:17:"tests of the best";s:1:"j";s:25:"{"doc":"core of reactor"}";}}}i:5;a:3:{s:8:"sphinxql";s:68:"SELECT id, REGEX(j.doc, 'core') as c, title, j FROM test_d WHERE c>0";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:1:"1";s:1:"c";s:1:"1";s:5:"title";s:15:"do it test blue";s:1:"j";s:48:"{"price":[11,15],"doc":"manticore is very good"}";}i:1;a:4:{s:2:"id";s:1:"2";s:1:"c";s:1:"1";s:5:"title";s:17:"tests of the best";s:1:"j";s:25:"{"doc":"core of reactor"}";}}}i:6;a:3:{s:8:"sphinxql";s:79:"SELECT id, REGEX(to_string(j.price), '11') as c, title, j FROM test_d WHERE c>0";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:1:"1";s:1:"c";s:1:"1";s:5:"title";s:15:"do it test blue";s:1:"j";s:48:"{"price":[11,15],"doc":"manticore is very good"}";}i:1;a:4:{s:2:"id";s:1:"3";s:1:"c";s:1:"1";s:5:"title";s:13:"the wild west";s:1:"j";s:12:"{"price":11}";}}}i:7;a:3:{s:8:"sphinxql";s:79:"SELECT id, REGEX(to_string(j.price), '5]') as c, title, j FROM test_d WHERE c>0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:2:"id";s:1:"1";s:1:"c";s:1:"1";s:5:"title";s:15:"do it test blue";s:1:"j";s:48:"{"price":[11,15],"doc":"manticore is very good"}";}}}i:8;a:3:{s:8:"sphinxql";s:58:"SELECT id, title, j FROM rt1 WHERE REGEX(j.doc, 'is | of')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:15:"do it test blue";s:1:"j";s:48:"{"price":[11,15],"doc":"manticore is very good"}";}i:1;a:3:{s:2:"id";s:1:"2";s:5:"title";s:17:"tests of the best";s:1:"j";s:25:"{"doc":"core of reactor"}";}}}i:9;a:3:{s:8:"sphinxql";s:61:"SELECT id, title, j FROM test_d WHERE REGEX(j.doc, 'core of')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"2";s:5:"title";s:17:"tests of the best";s:1:"j";s:25:"{"doc":"core of reactor"}";}}}i:10;a:3:{s:8:"sphinxql";s:59:"SELECT id, title, j FROM test_d WHERE REGEX(title, 'test?')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:15:"do it test blue";s:1:"j";s:48:"{"price":[11,15],"doc":"manticore is very good"}";}i:1;a:3:{s:2:"id";s:1:"2";s:5:"title";s:17:"tests of the best";s:1:"j";s:25:"{"doc":"core of reactor"}";}}}}}