CREATE TABLE `words` (
`word_id` INT NOT NULL,
`language_id` INT NOT NULL,
`word` VARCHAR(45) NULL);
UPDATE `table` SET
`email` = IF(LOCATE('Мыло|', `info`) = 0, NULL,
SUBSTRING_INDEX(SUBSTRING_INDEX(`info`, 'Мыло|', -1), '|', 1)),
`phone` = IF(LOCATE('Телефон|', `info`) = 0, NULL,
SUBSTRING_INDEX(SUBSTRING_INDEX(`info`, 'Телефон|', -1), '|', 1)),
`skype` = IF(LOCATE('Skype|', `info`) = 0, NULL,
SUBSTRING_INDEX(SUBSTRING_INDEX(`info`, 'Skype|', -1), '|', 1));
$req = $mysqli->prepare(
"SELECT `id` FROM `content` ".
"WHERE ('' = ? OR `lic` = ?) ".
"AND ('' = ? OR `selection` = ?) ".
"AND ('' = ? OR `type` = ?)"
);
$req->bind_param('ssssss', $lic, $lic, $selection, $selection, $type, $type);
UNION (SELECT 0 as Orders, 0 as Hours)
UNION (SELECT 0 as Orders, 1 as Hours)
...
UNION (SELECT 0 as Orders, 23 as Hours)
Не знаю, как именно это будет записываться в MSSQL UPDATE `table` SET `updated` = 0 WHERE `user_id` = $uid
INSERT INTO `table` (`user_id`, `obj_id`, `updated`) VALUES ($uid, $oid, 1)
ON DUPLICATE KEY UPDATE `updated` = 1
DELETE FROM `table` WHERE `user_id` = $uid AND `updated` = 0