title: Same query works different on two different machines
body: <p>This MySQL query</p>
  
  <pre><code>SELECT id FROM product WHERE title LIKE '%spoon%'
  </code></pre>
  
  <p>works fine on in MySQL on machine #1 and returns all products with <code>spoon</code> anywhere in the title string</p>
  
  <pre><code>('black spoon', 'teaspoon', 'red spoons')
  </code></pre>
  
  <p>Some time ago I migrated the whole thing to a machine #2 but the exact same query returns different number of results and from some reason it only returns products with word <code>teaspoons</code> in the title (no eg. <code>black spoon</code> among the results)</p>
  
  <p>Both MySql servers are version 5.0.51a. That particular product table is exactly the same on both machines with all fields the exact same type, length etc.</p>
  
  <p>Any ideas?</p>