Re: [Asterisk-Users] Re: OT : For the SQL gurus..

[WipeOut]

Reinhard Max wrote:

On Mon, 10 Nov 2003 at 13:34, WipeOut wrote:

 

I guess I am going to have to look through the table multiple times
dropping the last digit on each select until I get a result..
   

You could also try this one to see which one is faster:

 SELECT *, length(code)
 FROM a
 WHERE code = '00442085673456'
    OR code = '0044208567345'
    OR code = '004420856734'
    OR code = '00442085673'
    OR code = '0044208567'
    OR code = '004420856'
    OR code = '00442085'
    OR code = '0044208'
    OR code = '004420'
    OR code = '00442'
    OR code = '0044'
 ORDER BY length(code) DESC;
Again, the first row in the result set is the one you are after.

cu
        Reinhard
 

That works quite well.. result in 0.11 seconds..

I just have to work out now how to create the query in my code.. :)

Thanks a lot..

_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users