title: Oracle SQL using Like for a wildcard
body: <p>I know you can use LIKE for a select statement to search for a string and then use wildcards to match that string.. ex:</p>
  
  <p><code>Select * from table where first_name LIKE '%r%';</code></p>
  
  <p>Would return names such as robert, roland, craig, etc.</p>
  
  <p>I'm curious how you would search for an actual wildcard in the string such as the %:</p>
  
  <p><code>Select * from table where values LIKE '%  %  %';</code></p>
  
  <p>(the middle % being what you would be looking for) (obviously this is not the correct way to do it which is why I'm asking).</p>