mysql> select * from location3 where username=41215500329; +-------------+-------------------------------------+---------------------+ | username | contact | expires | +-------------+-------------------------------------+---------------------+ | 41215500329 | sip:41215500329@212.147.8.105:57422 | 2011-06-30 19:18:52 | +-------------+-------------------------------------+---------------------+ 1 rows in set (0.00 sec) mysql> select * from sippeers2 where name like '41215500329%'; +------+---------------+---------------+-----------+----------+---------------+-------+------------+-------------+----------------------------------+------+ | id | name | host | context | insecure | ipaddr | port | regseconds | username | md5secret | nat | +------+---------------+---------------+-----------+----------+---------------+-------+------------+-------------+----------------------------------+------+ | 4255 | 41215500329 | dynamic | forbidden | no | 212.147.8.105 | 57422 | 1309454332 | 41215500329 | 178c4c990a5995dd3e81d9bf5d5aeb7a | yes | | 7558 | 41215500329_1 | 212.147.8.105 | forbidden | no | 212.147.8.105 | 57422 | NULL | NULL | NULL | yes | +------+---------------+---------------+-----------+----------+---------------+-------+------------+-------------+----------------------------------+------+ 2 rows in set (0.00 sec)