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

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