"like" works like contain?

[KRambo]

SELECT uri, ts, partid FROM keywords WHERE uri like 'com.wiggle.www:http/' AND (keywords like 'adidas' OR keywords like 'nike' ); .The query with id leads.149803e8-ce57-46ad-8e52-e058d42e149c COMPLETED Please wait ... +-----------------------+----------------------------------------------------------------+-------------------+ |default.keywords.partid|default.keywords.uri |default.keywords.ts| +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/nike-womens-nike-df-epic-run-boy-short-fa14/|1411406580659 | +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/nike-free-50-shoes-fa14-blackwhite/ |1410876841667 | +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/nike-womens-nike-df-epic-run-boy-short-fa14/|1410884376816 | +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/nike-free-50-shoes-fa14-blackwhite/ |1410876841667 | +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/adidas-originals/ |1410865595311 | +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/adidas-originals/ |1411389433734 | +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/nike-womens-miler-long-sleeve-top-fa14/ |1410884427064 | +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/nike-womens-lunareclipse-4-shoes-fa14/ |1411406690664 | +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/nike-free-50-shoes-fa14/ |1411406700683 | +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/nike-impossibly-light-jacket-fa14/ |1411406650619 | +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/nike-free-50-shoes-fa14/ |1411406700683 | +-----------------------+----------------------------------------------------------------+-------------------+ |ecom_prod_name:000 |com.wiggle.www:http/nike-9-phenom-2-in-1-short-su14/ |1410875255364 | +-----------------------+----------------------------------------------------------------+-------------------+