Advertisement
Guest User

Untitled

a guest
Feb 7th, 2016
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. CREATE PROCEDURE `Storedproc`(IN getwhereconditon varchar(1000))
  2. BEGIN
  3. set @param=getwhereconditon ;
  4. SET @S=concat('Select * from table where (1)',@param);
  5. PREPARE stmt1 FROM @s;
  6. EXECUTE stmt1;
  7. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement