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
0 comments:
Post a Comment