toups toups - 4 months ago 30
SQL Question

Oracle SQL using Like for a wildcard

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