I want to take entries from database having % ,how to do that I am doing: select * from tablename where columnname like '%%' but not working How can i achieve that
I believe it varies on the DBMS but since % is a special character, if you want to reference it as a literal you need to use something like \% (MySQL usage).
For example if you wanted to find all rows with a column that contains a %, the query would be:
Note the % before and after \% for wildcard matching.