Syntax error in flask MySQL LIKE concat query

Question

I'm using MySQL with Python Flask and trying to do a search query with LIKE concat however I am getting a Syntax error with it or a Type Error if I use different marks around my symbols.

name_search = form.name.data
cursor.execute('SELECT id, name, surname FROM users WHERE surname LIKE CONCAT ('%', '%s', '%')', [name_search])

Jason Groulx · Accepted Answer · 2020-05-13 15:38:54Z

1

You could add the percentage signs within the variable

cursor.execute("SELECT id, name, surname FROM users 
    WHERE surname LIKE '{}'".format("%" + name_search + "%"))

edited May 13, 2020 at 15:38

answered May 13, 2020 at 15:30

Jason Groulx

4103 silver badges10 bronze badges

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

1 Comment

AshleeCW Over a year ago

Was able to use this to get to where I needed thank you!

Collectives™ on Stack Overflow

Syntax error in flask MySQL LIKE concat query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related