title: Why does drupal use Like rather than Equal operator in db_select()
body: <pre><code>function user_account_form_validate($form, &amp;$form_state) {
      ...
      db_select('users')-&gt;fields('users', array('uid'))-&gt;condition('uid', $account-&gt;uid, '&lt;&gt;')-&gt;condition('name', db_like($form_state['values']['name']), 'LIKE')-&gt;range(0, 1)-&gt;execute()-&gt;fetchField()
      ...
  }
  </code></pre>
  
  <p>this code <code>condition('name', db_like($form_state['values']['name']), 'LIKE')</code> use 'Like' to compare name field, why not use '='?</p>