title: How to Use a Wildcard (%) in Pandas read_sql()
body: <p>I am trying to run a MySQL query that has a text wildcard in as demonstrated below:</p>
  
  <pre><code>import sqlalchemy
  import pandas as pd
  
  #connect to mysql database
  engine = sqlalchemy.create_engine('mysql://user:@localhost/db?charset=utf8')
  conn = engine.connect()
  
  #read sql into pandas dataframe
  mysql_statement = """SELECT * FROM table WHERE field LIKE '%part%'; """
  df = pd.read_sql(mysql_statement, con=conn)
  </code></pre>
  
  <p>When run I get the error as shown below related to formatting. </p>
  
  <blockquote>
    <p>TypeError: not enough arguments for format string</p>
  </blockquote>
  
  <p>How can I use a wild card when reading MySQL with Pandas?</p>