<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><div>Hi All,</div><div><br></div><div>Is it possible when implementing NAPTR records in the records table to add multiple entries within the content field of a record?</div><div><br></div><div>Im just trying to reduce the number of entries in the database, so wondered if I could have more than one content entry, and if so how do you split them up?</div><div><br></div><div>So for example I have;</div><div><br></div><div><br></div><div> select * from records;</div><div>+----+-----------+---------------------------+-------+-------------------------------------------------------------+-------+------+-------------+</div><div>| id | domain_id | name | type | content | ttl | prio | change_date |</div><div>+----+-----------+---------------------------+-------+-------------------------------------------------------------+-------+------+-------------+</div><div><br></div><div>| 27 | 1 | *.0.3.7.7.4.4.e164.sip.mn | NAPTR | 2 10 "U" "E2U+sip" "!^(.*)$!sip:\\1@195.219.240.46!". | 120 | NULL | NULL |</div><div>| 26 | 1 | *.0.3.7.7.4.4.e164.sip.mn | NAPTR | 2 10 "U" "E2U+sip" "!^(.*)$!sip:\\1@195.219.240.50!". | 120 | NULL | NULL |</div><div><br></div><div>Can I add both 2 10 "U" "E2U+sip" "!^(.*)$!sip:\\1@195.219.240.46!". and 2 10 "U" "E2U+sip" "!^(.*)$!sip:\\1@195.219.240.50!". into the content of id 27 without breaking a query?</div><div><br></div><div>Many thanks</div><div><br></div><div>Jon</div><div><br></div> </div></body>
</html>