The concatenation of MySQL stored procedure variables

Splicing of stored procedure variables sometimes we need to blur the query, but at the same time we have to use the variable in the fuzzy query, we want to join the variable after a% to match the fuzzy query then we will use the Concat function example is as follows: Www.2cto.com SELECT C    Ount (ID) from the config WHERE name like concat (studentname, '% ');    Where Studentname is a variable, if the value of copy studentname = ' Lee ' then the effect is equivalent to SELECT count (id) from the config WHERE name like ' li% ';     Pay attention to punctuation. Author god123209

The concatenation of MySQL stored procedure variables