Python MySQL Where

When selecting records from a table, you can filter the selection by using the "WHERE" statement:

Select record(s) where the address is "Park Lane 38": result:

host="localhost", user=" yourusername ", password=" yourpassword ", database="mydatabase" ) mycursor = mydb.cursor()

You can also select the records that starts, includes, or ends with a given letter or phrase.

% to represent wildcard characters:

Select records where the address contains the word "way":

host="localhost", user=" yourusername ", password=" yourpassword ", database="mydatabase" )

When query values are provided by the user, you should escape the values. This is to prevent SQL injections, which is a common web hacking technique to destroy or misuse your database. The mysql.connector module has methods to escape query values:

%s method:

host="localhost", user=" yourusername ", password=" yourpassword ", database="mydatabase" )

mycursor.execute(sql, adr)