mysql - How to use like condition in query to fetch strings that contains % symbol -

i have 3 strings entries in table sample , column test 1.abc 2.abc%d 3.abc%e want write query fetch records in column test contains abc% using condition. output should abc%d , abc%e.

have used "_" underscore character in sql query? may resolve issue.

    select * mytablename details 'abc%_%' or      select * mytablename details 'abc%_' or      select * mytablename details '%abc\%%' escape '\' or     select * mytablename details 'abc\%%' escape '\' 

all above queries solve issue, use appropriate query based on application need , requirement.

reference: use underscore character in wild card charecter of query gives me table result