I'm trying to pass my variable into a statement with 'LIKE' but I'm getting all kinds of formatting errors. I tried cursor.execute("SELECT title FROM movies WHERE title LIKE '%%s%'" %Keyword) and other variants of it, but nothing works. How can I get the LIKE statement to interprit my variable?
Im using MySQL workbench and the 'Keyword' variable stores input from a FORM tag in html. The whole project is based on making a search website.
According to the docs, you should not use this way of formatting your strings:
https://docs.python.org/3/library/stdtypes.html#printf-style-string-formatting
Note The formatting operations described here exhibit a variety of quirks that lead to a number of common errors (such as failing to display tuples and dictionaries correctly). Using the newer formatted string literals, the str.format() interface, or template strings may help avoid these errors. Each of these alternatives provides their own trade-offs and benefits of simplicity, flexibility, and/or extensibility.
Example with .format:
query = "SELECT title FROM movies WHERE title LIKE '%{s}%'".format(s=Keyword)
cursor.execute(query)
