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

[Reinhard Max]

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