Oracle SQL using Like for a wildcard

Question

I know you can use LIKE for a select statement to search for a string and then use wildcards to match that string.. ex:

Select * from table where first_name LIKE '%r%';

Would return names such as robert, roland, craig, etc.

I'm curious how you would search for an actual wildcard in the string such as the %:

Select * from table where values LIKE '% % %';

(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).

Answer 1

How about

LIKE '%\%%' ESCAPE '\'

http://docs.oracle.com/cd/B12037_01/server.101/b10759/conditions016.htm