mysql> select * from service where remote_id_at_url like '%Fieldjournal%'; +-------+--------------------------------------+-----------------+----------------------------------------------------------------------+---------------------------------------+----------+---------------------+---------------------+---------+-------------+-------------+----------+ | id | uuid | service_type_id | url | remote_id_at_url | agent_id | created | modified | deleted | description | ws_password | sync_key | +-------+--------------------------------------+-----------------+----------------------------------------------------------------------+---------------------------------------+----------+---------------------+---------------------+---------+-------------+-------------+----------+ | 2952 | d62a1c05-3dd0-4c5b-8c66-08928d9aed7d | 16130 | http://pontikka.fmnh.helsinki.fi/biocase/pywrapper.cgi?dsa=mustikka2 | Fieldjournal.org observation database | 3029 | 2012-03-08 10:21:56 | 2012-03-08 10:21:56 | NULL | NULL | NULL | 0 | | 15452 | 3146e176-354e-11e2-918b-00145eb45e9a | 16130 | http://pontikka.fmnh.helsinki.fi/biocase/pywrapper.cgi?dsa=mustikka2 | Fieldjournal.org observation database | 14451 | 2012-11-23 10:14:32 | 2012-11-23 10:14:32 | NULL | NULL | NULL | NULL | +-------+--------------------------------------+-----------------+----------------------------------------------------------------------+---------------------------------------+----------+---------------------+---------------------+---------+-------------+-------------+----------+ 2 rows in set (0.02 sec) 0 mysql> select * from service where url like '%http://pontikka.fmnh.helsinki.fi/biocase/pywrapper.cgi?dsa=mustikka2%'; +-------+--------------------------------------+-----------------+----------------------------------------------------------------------+---------------------------------------+----------+---------------------+---------------------+---------+-------------+-------------+----------------------------------+ | id | uuid | service_type_id | url | remote_id_at_url | agent_id | created | modified | deleted | description | ws_password | sync_key | +-------+--------------------------------------+-----------------+----------------------------------------------------------------------+---------------------------------------+----------+---------------------+---------------------+---------+-------------+-------------+----------------------------------+ | 2952 | d62a1c05-3dd0-4c5b-8c66-08928d9aed7d | 16130 | http://pontikka.fmnh.helsinki.fi/biocase/pywrapper.cgi?dsa=mustikka2 | Fieldjournal.org observation database | 3029 | 2012-03-08 10:21:56 | 2012-03-08 10:21:56 | NULL | NULL | NULL | 0 | | 15453 | e0599498-357f-11e2-918b-00145eb45e9a | 16130 | http://pontikka.fmnh.helsinki.fi/biocase/pywrapper.cgi?dsa=mustikka2 | NULL | 14452 | 2012-11-23 16:10:11 | 2012-11-23 16:10:11 | NULL | NULL | NULL | 81992b94b9405583cdc516ce762462e9 | +-------+--------------------------------------+-----------------+----------------------------------------------------------------------+---------------------------------------+----------+---------------------+---------------------+---------+-------------+-------------+----------------------------------+ 2 rows in set (0.03 sec) mysql> select * from service where url like '%http://pontikka.fmnh.helsinki.fi/biocase/pywrapper.cgi?dsa=mustikka2%'; +-------+--------------------------------------+-----------------+----------------------------------------------------------------------+---------------------------------------+----------+---------------------+---------------------+---------+-------------+-------------+----------------------------------+ | id | uuid | service_type_id | url | remote_id_at_url | agent_id | created | modified | deleted | description | ws_password | sync_key | +-------+--------------------------------------+-----------------+----------------------------------------------------------------------+---------------------------------------+----------+---------------------+---------------------+---------+-------------+-------------+----------------------------------+ | 2952 | d62a1c05-3dd0-4c5b-8c66-08928d9aed7d | 16130 | http://pontikka.fmnh.helsinki.fi/biocase/pywrapper.cgi?dsa=mustikka2 | Fieldjournal.org observation database | 3029 | 2012-03-08 10:21:56 | 2012-03-08 10:21:56 | NULL | NULL | NULL | 0 | | 15454 | aeb78d18-3580-11e2-918b-00145eb45e9a | 16130 | http://pontikka.fmnh.helsinki.fi/biocase/pywrapper.cgi?dsa=mustikka2 | Fieldjournal.org observation database | 14453 | 2012-11-23 16:15:57 | 2012-11-23 16:15:57 | NULL | NULL | NULL | 81992b94b9405583cdc516ce762462e9 | +-------+--------------------------------------+-----------------+----------------------------------------------------------------------+---------------------------------------+----------+---------------------+---------------------+---------+-------------+-------------+----------------------------------+ 2 rows in set (0.02 sec)