How to use %x% wildcard in python using SQL

Question

input_uni = request.form.get("search")
uni = db.execute("SELECT * FROM unis WHERE name LIKE :name OR country LIKE :country", name=input_uni, country=input_uni)

Does name=f"%{inpunt_uni}%" do what you want?

jordanm
– jordanm

2021-02-09 16:47:21 +00:00
Commented Feb 9, 2021 at 16:47 — jordanm
– jordanm, Commented Feb 9, 2021 at 16:47
Yes it did, Thank you so much jordamn

Nicole
– Nicole

2021-02-09 19:58:52 +00:00
Commented Feb 9, 2021 at 19:58 — Nicole
– Nicole, Commented Feb 9, 2021 at 19:58

ScaisEdge · Accepted Answer · 2021-02-09 16:48:59Z

1

You clould use concat around you param name for build a proper like pattern without % issues

SELECT * FROM unis WHERE name LIKE concat('%', :name, '%')  
   OR country LIKE concat('%', :country, '%');

answered Feb 9, 2021 at 16:48

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

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

2 Comments

jordanm Over a year ago

Does using concat() have implications on index usage?

ScaisEdge Over a year ago

yes .. the use of function don't allow the use of index .. ....but also the use of wildchar in like produce bad performance .. so for like operator the use of caoncat is not so bad

Collectives™ on Stack Overflow

How to use %x% wildcard in python using SQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related