Like in mysqldb python

# you can't have '%' directly onto the query, you have to pass it as args
c.execute("SELECT * FROM data WHERE params LIKE %s LIMIT 1", ("%" + param + "%",))

Source: stackoverflow.com

Similar codes

0 vote201 views1 answer
Where to import render in django
Python Django
0 vote122 views1 answer
Facet grid, barplot, catplot
Python
0 vote122 views1 answer
Pystache unescaped characters
Python
0 vote119 views1 answer
Pandas qcut
Python
16 votes148 views6 answers
How to take integer input in python
Python
1 vote110 views1 answer
Flask run app reset on change
Python Flask
1 vote141 views1 answer
Remove duplicate rows in csv file python
Python
11 votes140 views3 answers
If elseif in single line python
Python
0 vote165 views1 answer
Rename a variable using .format in python
Python
0 vote147 views1 answer
Python import
Python