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

[WipeOut]

Reinhard Max wrote:

>On Mon, 10 Nov 2003 at 12:33, Reinhard Max wrote:
>
>  
>
>> SELECT DISTINCT *,length(code)
>> FROM a
>> WHERE '00442085673456' LIKE (code || '%')
>> ORDER length(code) DESC;
>>    
>>
>        ^
>        BY
>
>Oops, that one got lost when I re-formatted the query.
>
>cu
>	Reinhard
>
>  
>
Hi Reinhard,

That statement appeares to run on MySQL without any error but returns an 
empty result..

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

Later..