mysql> select * from location3 where username=41215504126; +-------------+------------------------------------+---------------------+ | username | contact | expires | +-------------+------------------------------------+---------------------+ | 41215504126 | sip:41215504126@212.147.8.105:1240 | 2011-06-30 19:26:44 | +-------------+------------------------------------+---------------------+ 1 row in set (0.00 sec) mysql> select * from sippeers2 where name like '41215504126%'; +------+---------------+---------------+-----------+----------+---------------+------+------------+-------------+----------------------------------+------+ | id | name | host | context | insecure | ipaddr | port | regseconds | username | md5secret | nat | +------+---------------+---------------+-----------+----------+---------------+------+------------+-------------+----------------------------------+------+ | 2522 | 41215504126 | dynamic | forbidden | no | 212.147.8.105 | 1240 | 1309454804 | 41215504126 | 7d4f5a3b14ac452fbb1169d7c183725b | yes | | 7559 | 41215504126_1 | 212.147.8.105 | forbidden | no | 212.147.8.105 | 1240 | NULL | NULL | NULL | yes | +------+---------------+---------------+-----------+----------+---------------+------+------------+-------------+----------------------------------+------+ 2 rows in set (0.00 sec)