title: mysql full text search boolean mode with spaces
body: <p>I have select for full text search</p>
  
  <pre><code>SELECT * FROM datatable WHERE MATCH(field1, field2, field3, field4) 
  AGAINST('C 100 330 00 75*' IN BOOLEAN MODE)
  </code></pre>
  
  <p>C 100 330 00 75 in field2, in field1 the same data but without spaces
  C1003300075 ,  in field3 data like "here we are", or "delta star".</p>
  
  <p>Select work for all fields expect for field2 - (C 100 330 00 75) .
  So what's wrong? If I remove spaces before search it will affect on another columns. I need search as user will input, with spaces and not spaces.</p>
  
  <p>Any suggestions?
  Thanks</p>