title: mysql using variables with regex
body: <p>how do i go about using Mysql variables inside... Mysql regex?</p>
  
  <p>for example, </p>
  
  <pre><code>SET @my_var = (
  SELECT 
  year 
  FROM blah
  LIMIT 1);
  
  SELECT 
  foo,
  bar
  FROM my_table
  WHERE date REGEXP @my_var%
  </code></pre>
  
  <p>also tried... <code>WHERE date REGEXP '@my_var%'</code></p>
  
  <p>what i'm trying to do is... <code>WHERE date REGEXP '2015%'</code></p>