title: Adding Index to column in mysql
body: <p>How do I create an index with PHPmyadmin?</p>
  
  <p>I have a database with 5,000 rows of</p>
  
  <pre><code>ID | IP | DATE
  </code></pre>
  
  <p>Before added data to this table I made <code>id</code> as Primary Key,</p>
  
  <p>The website use this query:</p>
  
  <pre><code>mysql_query("SELECT * FROM users WHERE ip = '$ip'");
  </code></pre>
  
  <p>I read today that indexes can speed up and performance, 
  and in my case how do i need to add index to IP column,</p>
  
  <p>I am to phpmyadmin and to actions I see "Add unique index" and "Add index" options,
  Im new in this, appreciate your help, thank you.</p>