title: mysql fix Using where;
body: <p>My SQL Query:</p>
  
  <pre><code>SELECT *
  FROM updates_cats
  WHERE uid =118697835834
  ORDER BY created_date ASC
  </code></pre>
  
  <p>Current Indexes:</p>
  
  <pre><code>index1(uid, created_date)
  </code></pre>
  
  <p>EXPLAIN EXTENDED result:</p>
  
  <pre><code>1 SIMPLE updates_cats ref index1 index1 8 const 2 100.00 Using where
  </code></pre>
  
  <p>How can i fix the Extra field where it has Using where so it can use the indexes instead?</p>
  
  <p>EDIT: SHOW CREATE TABLE:</p>
  
  <pre><code>CREATE TABLE `updates_cats` (
   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
   `u_cat_id` bigint(20) NOT NULL DEFAULT '0',
   `uid` bigint(20) NOT NULL,
   `u_cat_name` text COLLATE utf8_unicode_ci NOT NULL,
   `total_updates` int(11) unsigned NOT NULL DEFAULT '0',
   `created_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   PRIMARY KEY (`id`),
   KEY `index1` (`uid`,`created_date`)
  ) ENGINE=MyISAM AUTO_INCREMENT=23522 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
  </code></pre>