[Asterisk-Users] Re: Asterisk-Users Digest, Vol 5, Issue 192

Mike Mattice mike+asterisk-users at forestsidingsupply.com
Tue Dec 14 09:38:47 MST 2004


On Tue, Dec 14, 2004 at 11:20:08AM -0500, VoIPCarib wrote:
> mysql> SELECT * FROM routes WHERE "^13237309880" RLIKE pattern ORDER BY 
> LENGTH(pattern) DESC;
> It shows a few other routes before the USA, but ASTCC is written to use the 
> first row in the result table, which in this case wiould be Bangladesh 
> (880). But this would be incorrect since I am dialing USA.

Your pattern needs to actually be in the pattern field.  IE. have the ^
in it.  Remove the ^ from the phone number too. :)


-- 
Mike Mattice - Systems Programmer and Administrator



More information about the asterisk-users mailing list