title: Python MySQLdb WHERE SQL LIKE
body: <p>I have recently started to learn Python and MySQL for web purposes and I have run into a following problem :</p>
  
  <p>I want to pull out from a mysql database one record that contains any text that I enter in param section, howerver I am running into following problem when making a query:</p>
  
  <pre><code>traceback (most recent call last):
    File "/Users/Strielok/Desktop/test.py", line 13, in &lt;module&gt;
      c.execute("SELECT * FROM data WHERE params LIKE ('%s%') LIMIT 1"  % (param))
  TypeError: not enough arguments for format string
  </code></pre>
  
  <p>Here is my code:</p>
  
  <pre><code>import MySQLdb
  
  
  
  db = MySQLdb.connect (host = "localhost",
                            user = "root",
                            passwd = "root",
                            db = "test")
  param = "Test"
  
  par = param
  
  c = db.cursor()
  
  c.execute("SELECT * FROM data WHERE params LIKE ('%s%') LIMIT 1"  % (param))
  
  
  data = c.fetchall()
  print data
  
  c.close()
  </code></pre>
  
  <p>Thanks in advance.</p>