Searching char "%" using LIKE in MySQL

[Anon]

Hallo,
I have to perform search through the base for character "%" using LIKE operator. Any idea how to do this.

Igor.

[Anon]

Try escaping the % you are looking for,
i.e.:
"select * from test where name like '%\%%'";