title: Unknown column 'xyz' in 'where clause'
body: <p>I created a user defined sql query that doesn't work.  Users are supposed to be able to enter search strings in an input field, submit then see the results of their search but everytime I enter a search for something that I know is in the database I get the unknown column "x" in "where clause" error message.</p>
  
  <p>Would you please help me fix the problem?  Here's the code that i wrote for it so far...</p>
  
  <pre><code>...
  mysql_select_db("mydb", $c);
  $search = $_POST['search'];
  
  $rslt = mysql_query("SELECT * FROM mytable
  WHERE 'mycolumn' RLIKE $search");
  
  while($row = mysql_fetch_array($rslt))
    {
    echo $row['myrow'];
    echo "&lt;br /&gt;";
    }
  
  if (!$row)
    {
    die('uh oh: ' . mysql_error());
    }
  
  ?&gt;
  </code></pre>