title: Syntax error on mysql in c#
body: <p>this is my query which i generate from c# </p>
  
  <pre><code>Select * from contac 
  where ((LCASE(first_name) = '' and LCASE(sur_name) = 'bn d. o’connor &amp; co' ) 
  or 
  (LCASE(first_name) = 'bn d. o’connor &amp; co' and LCASE(sur_name) = '' )) 
  and 
  Medicom_GP_KEY is null
  </code></pre>
  
  <p>but if i execute and fill Data table means it shows error like </p>
  
  <blockquote>
    <p>You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'connor &amp; co' ) or (LCASE(first_name) = 'bn d. o'connor &amp; co' and LCASE(sur_' at line 1</p>
  </blockquote>
  
  <p>i do not know where the error is occurs.</p>