mysql> SELECT url FROM `pagerank` where url like '%kn.wikipedia.org/%'; +--------------------------------------------------------------------------------------------------+ | url | +--------------------------------------------------------------------------------------------------+ | kn.wikipedia.org/ | | kn.wikipedia.org/wiki/ | | kn.wikipedia.org/wiki/ | | kn.wikipedia.org/ | | kn.wikipedia.org/wiki/ | | kn.wikipedia.org/wiki/ | | kn.wikipedia.org/wiki/ | | kn.wikipedia.org/wiki/ | | kn.wikipedia.org/wiki/ | | kn.wikipedia.org/wiki/ | | kn.wikipedia.org/wiki/%E0%B2%AE%E0%B3%81%E0%B2%96%E0%B3%8D%E0%B2%AF_%E0%B2%AA%E0%B3%81%E0%B2%9F | | kn.wikipedia.org/wiki/ | | kn.wikipedia.org/wiki/ | | kn.wikipedia.org/wiki/ | +--------------------------------------------------------------------------------------------------+ 14 rows in set (0.01 sec)