How to use LIKE operator???

[Guest_imported]

When I use the LIKE operator to find a String. How can I solve with the % and _ character.
If I want to find a record which contains a readly character '%' and '_'
For examples : I want to search in table A where the field name must include a string ' aa%aa '.
How to solve if I use Like operator
Select * from A where name LIKE ' aa%aa '
and may be the result is false.

 

[Guest_imported]

try this
select * from table_name where col1 like '%\%%' escape '\';

 

[rcurva]

Or, in sqlplus

SET ESCAPE
SELECT *
FROM table1
WHERE col1 LIKE '%\%%';