test, MySQL - rextester

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

CREATE TABLE IF NOT EXISTS `table1_789745` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `article` varchar(50) DEFAULT NULL,
  `price` decimal(12,2) DEFAULT 0.00,
  `old_price` decimal(12,2) DEFAULT 0.00,
  `weight` decimal(13,3) DEFAULT 0.000,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `vendor` int(10) unsigned DEFAULT 0,
  `made_in` varchar(100) DEFAULT '',
  `new` tinyint(1) unsigned DEFAULT 0,
  `popular` tinyint(1) unsigned DEFAULT 0,
  `favorite` tinyint(1) unsigned DEFAULT 0,
  `tags` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `size` text DEFAULT NULL,
  `source` int(10) unsigned DEFAULT 1,
  `availability` int(10) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `article` (`article`),
  KEY `price` (`price`),
  KEY `old_price` (`old_price`),
  KEY `vendor` (`vendor`),
  KEY `new` (`new`),
  KEY `favorite` (`favorite`),
  KEY `popular` (`popular`),
  KEY `made_in` (`made_in`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `table1_789745` (`id`, `article`, `price`, `old_price`, `weight`, `image`, `thumb`, `vendor`, `made_in`, `new`, `popular`, `favorite`, `tags`, `color`, `size`, `source`, `availability`)
VALUES
	(1, 'bla-bla-bla', 0.00, 0.00, 0.000, NULL, NULL, 0, '', 0, 0, 0, NULL, NULL, '[\"\\u042f\\u0440\\u043e\\u0441\\u043b\\u0430\\u0432\\u0441\\u043a\\u0430\\u044f \\u043e\\u0431\\u043b\\u0430\\u0441\\\"]', 1, 1);

SELECT * FROM `table1_789745`;
SELECT COUNT(DISTINCT `article`) FROM `table1_789745` WHERE size LIKE '["\\\\u042f\\\\u0440%';
SELECT COUNT(DISTINCT `article`) FROM `table1_789745` WHERE size LIKE '%\\\\u042f\\\\u0440%';
SELECT COUNT(DISTINCT `article`) FROM `table1_789745` WHERE size LIKE '["\\\\u042A\\\\u0440%';

DROP TABLE `table1_789745`;


absolute service time: 0,36 sec