Меню
Что нового?

Непонятная ситуация с LIKE.

Buldozer

Новичок
Непонятная ситуация с LIKE.

Первые 13-ть строк соответсвуют шаблону, а вот дальше совпадения нет

PHP: 
mysql> select page_url from accepted_pages where page_url like "%_ip%" limit 20;
+------------------------------------------------------------------------------------------------------------+
| page_url |
+------------------------------------------------------------------------------------------------------------+
| /13807.html&id_shop=142&id_cat=4&model=apple_ipod_shuffle_1024mb&status=1 |
| /14648.html&id_shop=142&id_cat=4&model=apple_ipod_nano_2gb&status=1 |
| /16686.html&id_shop=142&id_cat=4&model=apple_ipod_mini_6gb&status=1 |
| /16932.html&id_shop=142&id_cat=&model=hp_ipaq_h2190_1&status=1 |
| /16933.html&id_shop=142&id_cat=&model=hp_ipaq_h2490_1&status=1 |
| /16934.html&id_shop=142&id_cat=&model=hp_ipaq_h1950_1&status=1 |
| /17658.html&id_shop=142&id_cat=4&model=philips_sa_167/00&status=1 |
| /17660.html&id_shop=142&id_cat=&model=philips_sa_175/02&status=1 |
| /17660.html&id_shop=142&id_cat=4&model=philips_sa_175/02&status=1 |
| /17663.html&id_shop=142&id_cat=&model=philips_sa_260/00&status=1 |
| /17663.html&id_shop=142&id_cat=4&model=philips_sa_260/00&status=1 |
| /17665.html&id_shop=142&id_cat=4&model=philips_expanium_exp_3460/00&status=1 |
| /20028.html&id_shop=142&id_cat=&model=hp_ipaq_h2790_1&status=1 |
| /modules.php?name=Downloads&d_op=ratedownload&lid=1070&ttitle=SharkSwipeT3&pid=palm |
| /modules.php?name=Downloads&d_op=ratedownload&lid=1071&ttitle=SharkSwipeTH&pid=palm |
| /modules.php?name=Downloads&d_op=ratedownload&lid=115&ttitle=FlyZip%20XR&pid=palm |
| /modules.php?name=Downloads&d_op=ratedownload&lid=115&ttitle=FlyZip_XR&pid=palm |
| /modules.php?name=Downloads&d_op=ratedownload&lid=1399&ttitle=Clipper_for_Palm_OS&pid=palm |
| /modules.php?name=Downloads&d_op=ratedownload&lid=1534&ttitle=Championship_Checkers_Pro_Board_Gam&pid=palm |
| /modules.php?name=Downloads&d_op=ratedownload&lid=1558&ttitle=Clip_PRO_Desktop_Component&pid=palm |
+------------------------------------------------------------------------------------------------------------+
я что-то путаю?
 
Войдите или зарегистрируйтесь для ответа.
Сверху