Oracle SQL using both for template

Question

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

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

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

I am curious how you will look for the actual pattern in a string such as%:

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

(average% is what you would be looking for) (obviously this is the wrong way to do this, so I ask).

Answer 1

What about

 LIKE '%\%%' ESCAPE '\' 

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

Answer 2

Just LIKE '%%' will be even easier.