mysql> select * from location3 where username=41215500336; +-------------+-------------------------------------+---------------------+ | username | contact | expires | +-------------+-------------------------------------+---------------------+ | 41215500336 | sip:41215500336@212.147.8.105:55129 | 2011-06-30 19:53:44 | +-------------+-------------------------------------+---------------------+ 1 row in set (0.00 sec) mysql> select * from sippeers2 where name like '41215500336%'; +------+---------------+---------------+-----------+----------+---------------+-------+------------+-------------+----------------------------------+------+ | id | name | host | context | insecure | ipaddr | port | regseconds | username | md5secret | nat | +------+---------------+---------------+-----------+----------+---------------+-------+------------+-------------+----------------------------------+------+ | 7139 | 41215500336 | dynamic | forbidden | no | 212.147.8.105 | 55129 | 1309456424 | 41215500336 | f16c0600d7b05d476d6ad221be1c8e8b | yes | | 7563 | 41215500336_1 | 212.147.8.105 | forbidden | no | 212.147.8.105 | 55129 | NULL | NULL | NULL | yes | +------+---------------+---------------+-----------+----------+---------------+-------+------------+-------------+----------------------------------+------+ 2 rows in set (0.00 sec)