UPDATE Admins
SET Admins.password = (SELECT password FROM Users WHERE UserID = 42)
WHERE AdminID = 23;DELIMITER $$
DROP PROCEDURE IF EXISTS `article_search`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `article_search`(IN search VARCHAR(255))
BEGIN
SET @search = search;
SET @query = 'SELECT * FROM articles ';
IF search <> '' THEN
SET @query = CONCAT(@query, ' WHERE name = ? ');
END IF;
PREPARE stmt FROM @query;
IF search <> '' THEN
EXECUTE stmt USING @search;
ELSE
EXECUTE stmt;
END IF;
DEALLOCATE PREPARE stmt;
END$$
DELIMITER ;CREATE PROCEDURE proc_IF (IN param1 INT, IN param2 VARCHAR(255))
BEGIN
SET @search_name = param2;
SET @query = 'SELECT * FROM articles ';
IF param1 = 0 THEN
@query = CONCAT(@query, ' WHERE name = ?')
END IF;
PREPARE stmt FROM @query;
EXECUTE stmt USING @search_name;
DEALLOCATE PREPARE stmt;
END