Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2014
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. delimiter $$
  2. USE `Test`$$
  3. DROP PROCEDURE IF EXISTS `DYNAMIC_MYSQL`$$
  4. CREATE PROCEDURE DYNAMIC_MYSQL()
  5. BEGIN
  6. DECLARE DONE INT;
  7. DECLARE CHECKNUMBER VARCHAR(50);
  8. DECLARE QUERY1 VARCHAR(100);
  9. DECLARE stmt VARCHAR(100);
  10. SET NUMBER='3131';
  11.  
  12. SET QUERY1=CONCAT('SELECT number FROM abc WHERE number LIKE "%',NUMBER,'%"');
  13. PREPARE stmt FROM @QUERY1;
  14. EXECUTE stmt;
  15. DEALLOCATE PREPARE stmt;
  16. SELECT QUERY1;
  17.  
  18. END;
  19.  
  20. SET @NUMBER='3131';
  21. SET @QUERY1='SELECT number FROM abc WHERE number LIKE CONCAT("%",?,"%")';
  22. PREPARE stmt FROM @QUERY1; EXECUTE stmt USING @NUMBER;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement