Like Query Using Mysql StoredProcedure in Asp.Net C#

Like Query Using  Mysql StoredProcedure

Search some details we are using mysql  Like Query for related words search now using Mysql Stored procedure.

LIKE CONCAT('%',SearchText,'%')

StoredProcedure Like Query

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_select_register`(In SearchText varchar(50))

BEGIN

 SELECT  * FROM register WHERE name LIKE CONCAT('%',SearchText,'%') limit 10;

END