title: MySQL SELECT * WHERE name = "something with a backslash \"
body: <p>I have a table</p>
  
  <pre><code>table_id | name   | amount
  1        | Arby\'s| 12
  2        | Wendy's| 8
  </code></pre>
  
  <p>I usually do a </p>
  
  <p>SELECT * WHERE table_id = whatever</p>
  
  <p>But I would like (instead) do:</p>
  
  <p>SELECT * WHERE name = "Arby\'s";</p>
  
  <p>However, I seem to be running into problems with the backslash. The result isn't showing up at all. I've also tried</p>
  
  <pre><code>SELECT * WHERE name = 'Arby's;
  </code></pre>
  
  <p>Without any luck.</p>
  
  <p>Is there any way to search by name if the name contains apostrophes or other special characters (ampersands etc?)</p>