Something

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)