Splicing of mysql Stored Procedure Variables

Mysql Stored Procedure variable concatenation sometimes requires fuzzy query, but at the same time we need to use the variable during fuzzy query, we want to splice a % after the variable to match the fuzzy query, then we will use the concat function example as follows: www.2cto.com SELECT count (id) FROM config WHERE name like concat (studentName, '%'); WHERE studentName is a variable. If the value of studentName is copied to 'lil', the effect is equivalent to SELECT count (id) FROM config WHERE name like 'Li % '. Pay attention to punctuation. author god123209