title: MySQL Fulltext with particular word order
body: <p>I am wondering if it is possible to do a MATCH() AGAINST() (fulltext) search in a way that words, who are not directly next to each other, need to be in a specific order? On my site, when users type words between double-quotes, the search will only display results that have those words in that particular order. For example, if this is the search term:</p>
  
  <pre><code>"pizza road"
  </code></pre>
  
  <p>it will return 'The best pizza down the road', but not 'the road to the best pizza'.</p>
  
  <p>I know that BOOLEAN mode will allow for 'phrase' searches, but this means the words need to be next to each other (separated with just a space, period, comma, etc), which obviously won't return either of the results listed above: <a href="http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html</a></p>
  
  <p>Currently I am using regexp to perform this action, but needless to say that this is a bad way to search a varchar column (pointlessly fulltext indexed), even though it is just little under 200,000 rows. So what I would like to know is if it is possible to perform the same search using just MATCH() AGAINST()? Or should I combine it with with the regexp? Or is there even another method I haven't thought of?</p>
  
  <p>I can provide table/ code samples upon request.</p>
  
  <p>Thanks in advance!</p>