Shulou(Shulou.com)05/31 Report--

It is believed that many inexperienced people don't know how to splice stored procedure variables in mysql, so this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Splicing of stored procedure variables

Sometimes we need fuzzy queries, but at the same time we need

We use variables in fuzzy queries, and we want to concatenate a% after the variables to match the fuzzy query.

Then the concat function will be used.

Examples are as follows: www.2cto.com

SELECT count (id) FROM config WHERE name like concat (studentName,'%')

Where studentName is a variable

If you copy the value of studentName ='Li'

Then the effect is equivalent to

SELECT count (id) FROM config WHERE name like 'Lee%'; pay attention to punctuation.

After reading the above, have you mastered how to concatenate stored procedure variables in mysql? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.