mysql> SELECT replace(BINARY `url`, ' ', 'SPACE') FROM `pagerank2` WHERE BINARY trim(url) like '%kn.wikipedia.org/%';
+--------------------------------------------------------------------------------------------------+
| replace(BINARY `url`, ' ', 'SPACE')                                                              |
+--------------------------------------------------------------------------------------------------+
| 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.00 sec)