[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..