I am using mysql which i have a stored procedure which has an input variable.

I want to use this variable in a select statement (with like clause).

Eg:

```
DELIMITER $$

DROP PROCEDURE IF EXISTS `DeleteDataByTransactionID` $$
CREATE DEFINER=`root`@`%` PROCEDURE `DeleteDataByTransactionID`(in **$TransactionID** varchar(50))

BEGIN

delete from sqlstatements where tempsql like '%'+ **$TransactionID** + '%';

END $$

DELIMITER ;

```

Thanks