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

[Mike Mattice]

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