title: Grant SELECT access to multiple MySQL tables using wildcard
body: <p>My database has multiple tables that begin with 'field_data_', and I would like to grant a user SELECT access with just MySQL query using the wildcard.</p>
  
  <p>I tried</p>
  
  <pre><code>GRANT SELECT ON db.field_data_% TO a_user@'localhost';
  </code></pre>
  
  <p>but am getting MySQL syntax error near the %.</p>