title: How do I query for Strings containing a letter more than once?
body: <p>How do I run a query in MySQL to search for Strings containing a character on more than one occurrence?</p>
  
  <p><code>SELECT * FROM animals WHERE name LIKE '%r%'</code> will only return animals that contain an 'r'..</p>
  
  <pre><code>+---------+------------+
  |    id   | name       |
  +---------+------------+
  |     1   | zebra      |
  |     14  | raccoon    |
  |     25  | parrot     | 
  |     49  | rhinoceros |
  +---------+------------+
  </code></pre>
  
  <p><code>SELECT * FROM animals WHERE name LIKE '%rr%'</code> will only return animals that contain an occurance of 'rr'..</p>
  
  <pre><code>+---------+------------+
  |    id   | name       |
  +---------+------------+
  |     25  | parrot     | 
  +---------+------------+
  </code></pre>
  
  <p>I would like to find any animal names that contain an 'r'.. lets say twice anywhere in the name.</p>
  
  <pre><code>+---------+------------+
  |    id   | name       |
  +---------+------------+
  |     25  | parrot     | 
  |     49  | rhinoceros |
  +---------+------------+
  </code></pre>
  
  <p>Anyone?</p>