How do we use % when performing a search query?

Question

Table     T1
Col1    Col2
%          1
X          2
%          3

I need to return the rows which are all having %. Simply how to search the string % in Oracle.

Answer 1

For example you run this query

mysql> select * from mytable where mycolumn like '%mytext%';

Above query will return you all the rows where mycolumn is containing mytext i.e. It will return a row which contains
abcmytextabc,
abcmytext
mytextabc

So in short % works as wildcard character in the same way how * works in linux.