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 vote200 views1 answer
Pandas remove item from dictionary
Python
0 vote205 views1 answer
Python print without optional argument
Python
2 votes195 views2 answers
Mode
Python
1 vote203 views1 answer
Can't convert np.ndarray of type numpy.object_.
Python
18 votes223 views3 answers
Run calc.exe inside python
Python
0 vote200 views1 answer
Azure functions read only file system
Python
0 vote170 views6 answers
How to write a correct python code
Python
0 vote202 views1 answer
How to iterate row wise using 2d integer array in python
Python
3 votes218 views1 answer
Rotate 2 dimensional list python
Python
0 vote140 views1 answer
Width and precision thousand separetor python
Python