title: Warning: #1292 Truncated incorrect DOUBLE value: 'xxx'
body: <p>I'm trying to create a MySQL query to select two teams</p>
  
  <p>Using the query below I keep getting this error and its not something I've come across before, google seems to offer a variety of answers but I'm unable to relate the fix to my query.</p>
  
  <pre><code>SELECT 
          m.idm,
          m.buteq1,
          m.buteq2,
          tf.eq_name,
          ts.eq_name  
          FROM wpap_match  m
               INNER JOIN wpap_equipes tf
                  on tf.eq_name = tf.id
               INNER JOIN wpap_equipes ts
                  on ts.eq_name = ts.id
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code> Warning: #1292 Truncated incorrect DOUBLE value: 'ESS'
  </code></pre>
  
  <p>Can any one help to fix this ?</p>