mysql> select * from location3 where username=41215500327; +-------------+------------------------------------+---------------------+ | username | contact | expires | +-------------+------------------------------------+---------------------+ | 41215500327 | sip:41215500327@85.3.159.248:55464 | 2011-06-30 19:01:24 | +-------------+------------------------------------+---------------------+ 1 row in set (0.00 sec) mysql> select * from sippeers2 where name like '41215500327%'; +------+---------------+--------------+-----------+----------+--------------+-------+------------+-------------+----------------------------------+------+ | id | name | host | context | insecure | ipaddr | port | regseconds | username | md5secret | nat | +------+---------------+--------------+-----------+----------+--------------+-------+------------+-------------+----------------------------------+------+ | 4253 | 41215500327 | dynamic | forbidden | no | 85.3.159.248 | 55464 | 1309453284 | 41215500327 | 7f2d55f1d98b6a7f34835ef75b1cfcb4 | yes | | 7556 | 41215500327_1 | 85.3.159.248 | forbidden | no | 85.3.159.248 | 55464 | NULL | NULL | NULL | yes | +------+---------------+--------------+-----------+----------+--------------+-------+------------+-------------+----------------------------------+------+ 2 rows in set (0.00 sec)