title: MySQL Match Against w/ additional condition: Use subquery?
body: <p>Suppose we have a table such as </p>
  
  <pre><code>CREATE TABLE test{
  title VARCHAR(32),
  city VARCHAR(32),
  description TEXT
  ...
  </code></pre>
  
  <p>And in a query say we have</p>
  
  <pre><code>SELECT * FROM test WHERE MATCH(title, description) AGAINST('xyz' IN NATURAL LANGUAGE MODE) AND city = 'ABC';
  </code></pre>
  
  <p>Will MySQL know to use the "city" condition first, or should we be more explicit and use a subquery?</p>