title: How to use dynamic variable in RMySQL LIKE Statement
body: <p>I'm trying to create a query my MySQL database using RMySQL. I want to find all queries that contain a variable I provide through R.</p>
  
  <p>For example:</p>
  
  <pre><code>z="name"
  dbSendQuery(conn, "SELECT Address FROM Test WHERE Business Like '%z%'")
  </code></pre>
  
  <p>Wher conn is my connection to my database, Address and Business are columns in a table Test.</p>
  
  <p>This doesn't work, as this causes the query to search for rows that contain the letter z, rather than what the variable z stands for. Any suggestions?</p>