title: mysql workbench cannot : update where like
body: <p>Normally i can update my rows w/ queries such as</p>
  
  <p><code>UPDATE t SET col1='123' WHERE col2 LIKE '%abc%';</code></p>
  
  <p>or</p>
  
  <p><code>UPDATE mydb.t SET col1='123' WHERE col2 LIKE '%abc%';</code></p>
  
  <p>But with MySQL Workbench I seem to only be able to <code>SELECT</code> but cannot <code>UPDATE</code> the tables with queries.</p>
  
  <p>Does anyone know a fix for working with workbench?</p>
  
  <p><strong>FIX</strong></p>
  
  <p>To disable safe mode, toggle the option in Preferences -> SQL Editor -> Query Editor and reconnect.</p>