--
-- Структура таблицы `products`
--
 
CREATE TABLE IF NOT EXISTS `products` (
`id` INT(3) UNSIGNED NOT NULL,
  `key` VARCHAR(40) NOT NULL,
  `title` VARCHAR(50) NOT NULL,
  `description` VARCHAR(60) DEFAULT NULL,
  `owned` INT(2) UNSIGNED NOT NULL,
  `sub_owned` INT(2) DEFAULT NULL,
  `labels` SET('hit','vegan') DEFAULT NULL,
  `price` INT(4) NOT NULL,
  `composition` VARCHAR(250) DEFAULT NULL,
  `weight` VARCHAR(15) DEFAULT NULL,
  `calories` VARCHAR(20) DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=126 ;
 
--
-- Структура таблицы `contents`
--
 
CREATE TABLE IF NOT EXISTS `contents` (
`id` INT(2) UNSIGNED NOT NULL,
  `key` VARCHAR(20) NOT NULL,
  `title` VARCHAR(20) NOT NULL,
  `included` enum('on','off') NOT NULL DEFAULT 'off'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
 
--
-- Структура таблицы `sub_contents`
--
 
CREATE TABLE IF NOT EXISTS `sub_contents` (
`id` INT(2) NOT NULL,
  `key` VARCHAR(20) NOT NULL,
  `title` VARCHAR(30) NOT NULL,
  `owned` INT(2) NOT NULL,
  `included` enum('on','off') NOT NULL DEFAULT 'on'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

SELECT * FROM products WHERE 
`composition` REGEXP '(огурец|суши|cola)' OR 
`description` REGEXP '(огурец|суши|cola)' OR 
`title` REGEXP '(огурец|суши|cola)' OR 
`owned` REGEXP '(огурец|суши|cola)' OR 
`sub_owned` REGEXP '(огурец|суши|cola)'