SELECT
@correct_answer_position := LOCATE("'correct'", `text`),
@comma_position := LOCATE(",", `text`, @correct_answer_position),
@length := @comma_position - @correct_answer_position,
SUBSTRING(`text`, @correct_answer_position, @length) AS 'correct_answer'
FROM `test`.`test`
SELECT
SUBSTRING(`text`, LOCATE("'correct'", `text`), LOCATE(",", `text`, LOCATE("'correct'", `text`)) - LOCATE("'correct'", `text`))
AS 'correct_answer'
FROM `test`.`test`
SELECT SUM(inner.`red`) FROM (
SELECT `red` FROM abtest ORDER BY id DESC LIMIT 5
) as `inner`
CREATE TABLE `test` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`some_field` CHAR(255) DEFAULT NULL,
PRIMARY KEY (`id`)
);
DELIMITER |
CREATE TRIGGER `set_default_value_from_last_row` BEFORE INSERT ON `test` FOR EACH ROW
BEGIN
IF (NEW.`some_field` IS NULL) THEN
SET NEW.`some_field` = (SELECT `some_field` FROM `test` WHERE `id` = (SELECT MAX(`id`) FROM `test`));
END IF;
END;|
// Каким-то образом получаем данные.
$field = "0;0;0";
// Распаковываем данные в массив
$pieces = explode(';', $field);
// Изменяем массив соответствующим образом
$pieces[1] = 2;
// Запаковываем данные вновь
$field = implode(';', $pieces);
// Проверяем
echo $field // Выведет 0;2;0
$array= array(1,2,3,4,5);
$query = "INSERT INTO `table`(nomer) VALUES ";
foreach ($array as $i=>$value) {
$query .= "({$value})";
if ($i+1 < count($array)) {
$query .= ", "
}
} // Result query: INSERT INTO `table`(nomer) VALUES (1), (2), (3), (4), (5)
$res = mysql_query($query);
/* Вычисление суммы за текущую неделю */
SELECT
SUM(`index`) AS 'this_week'
FROM
`table`
WHERE
`date` >= DATE_SUB(NOW(), INTERVAL (WEEKDAY(NOW())) DAY) AND
`date` <= NOW()
;
/* Вычисление суммы за прошлую неделю */
SELECT
SUM(`index`) AS 'last_week'
FROM
`table`
WHERE
`date` >= DATE_SUB(NOW(), INTERVAL (7+WEEKDAY(NOW())) DAY) AND
`date` <= DATE_SUB(NOW(), INTERVAL 7 DAY)
$stmt = $mysqli->prepare('SELECT `username` FROM `'.$tbl_USERS.'` WHERE `steam_id`=? LIMIT 1');
$stmt->bind_param('i', $_SESSION['steam_id']);
$stmt->execute();
$stmt->bind_result($username);
while ($stmt->fetch()) {
echo "username: {$username}" . PHP_EOL;
}
$stmt->close();
SELECT
CASE WHEN COUNT(`password`) = 0 THEN
'There is no results'
ELSE UPPER(md5(GROUP_CONCAT(CONCAT_WS(':',`pl_id`,`password`)))) END AS
'str'
FROM portal.`channels` c
WHERE name = '%s'
AND pl_id = '%d'