How to do pattern matching to a variable in mysql

Question

So im creating a procedure that accepts an argument namee and returns all users whose name is a substring of namee

    create procedure search_res(IN namee varchar(50))
    begin
    select * from usr where name like %namee%;
    end

But im getting the following error. #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%namee%; end' at line 3. What is the correct syntax?

adding quotes will match the word namee as such instead of the value inside namee. — Karthika Jayaprakash
– Karthika Jayaprakash, Commented Oct 11, 2014 at 14:20

Ram · Accepted Answer · 2014-10-11 15:34:58Z

2

Use CONCAT function

select * from usr where name like CONCAT('%',namee,'%');

answered Oct 11, 2014 at 15:34

Ram

3,09110 gold badges43 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to do pattern matching to a variable in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related