i used the below query to sort out the no of url s in the column , select count(col.name) from table name where colname like %http%; do any one could help me to solve the above scenario ... View more