title: How to make MySQL MATCH...AGAINST use various word separators?
body: <p>I have a table with 300K string values. These values contain all types of word separators so it looks like this:</p>
  
  <pre><code>id  value
  1   A B C
  2   A B_C
  3   A_B-C
  4   A-B-C
  </code></pre>
  
  <p>Let's say I want to find all four rows containing <code>A</code> and <code>B</code>. This query<br>
  <code>SELECT * FROM table WHERE MATCH(value) AGAINST('+A +B' IN BOOLEAN MODE);</code>
  will return only one row with space separated values:<br>
  <code>1   A B C</code></p>
  
  <p>Is there a way to make <code>MATCH...AGAINST</code> use other word separators? I tried to use <code>LIKE</code> and it was too slow.</p>