> 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.
...or you could do the 'only right thing': - Move to pgSQL and write a stored procedure to do it roy _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
