Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- delimiter $$
- USE `Test`$$
- DROP PROCEDURE IF EXISTS `DYNAMIC_MYSQL`$$
- CREATE PROCEDURE DYNAMIC_MYSQL()
- BEGIN
- DECLARE DONE INT;
- DECLARE CHECKNUMBER VARCHAR(50);
- DECLARE QUERY1 VARCHAR(100);
- DECLARE stmt VARCHAR(100);
- SET NUMBER='3131';
- SET QUERY1=CONCAT('SELECT number FROM abc WHERE number LIKE "%',NUMBER,'%"');
- PREPARE stmt FROM @QUERY1;
- EXECUTE stmt;
- DEALLOCATE PREPARE stmt;
- SELECT QUERY1;
- END;
- SET @NUMBER='3131';
- SET @QUERY1='SELECT number FROM abc WHERE number LIKE CONCAT("%",?,"%")';
- PREPARE stmt FROM @QUERY1; EXECUTE stmt USING @NUMBER;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement