title: How to escape dollar sign in mysql when executed by command line?
body: <p>I tried to update an hash password in MySql by command line.</p>
  
  <p>But I found the dollar sign make the final value wrong.</p>
  
  <pre><code>$ mysql -uhomestead -p'secret' foobarDB -e "UPDATE users SET 
   password='$2y$10$vmBPs',email='foobar@example.com' WHERE id = 1;"
  </code></pre>
  
  <p>The final value in password column turn out to be <code>y0</code> but not <code>$2y$10$vmBPs</code></p>
  
  <p>Can anyone give me some hint?Thanks</p>