RE: empty set

2011-04-26 Thread Rocio Gomez Escribano
ido de Souza Neto [mailto:j...@consultorweb.cnt.br] Enviado el: martes, 26 de abril de 2011 15:02 Para: mysql@lists.mysql.com Asunto: Re: empty set As far as I know, it isn´t possible. The right way is to check how many rows your select has returned. -- João Cândido de Souza Neto "&quo

Re: empty set

2011-04-26 Thread Jo�o C�ndido de Souza Neto
As far as I know, it isn´t possible. The right way is to check how many rows your select has returned. -- João Cândido de Souza Neto ""Rocio Gomez Escribano"" escreveu na mensagem news:000601cc03e2$fd3c9540$f7b5bfc0$@go...@ingenia-soluciones.com... > Hi! I'm not sure it would be possible

Re: Empty Set Query question

2001-05-01 Thread Erica B. Tanner
Thanks to all for the suggestions!! Turns out, if I use a regular expression instead of a text compare I get the desired result!! :) Thanks! Erica Gerald Clark wrote: > You are doing a text compare, and they have to match exactly, > including leading zeros after the dots. > > You might look a

Re: Empty Set Query question

2001-05-01 Thread Gerald Clark
You are doing a text compare, and they have to match exactly, including leading zeros after the dots. You might look at storing them as integers. MySQL has to functions INET_ATON() and INET_NTOA() to convert them back and forth to strings. Erica B. Tanner wrote: > Hello everyone. I am new to t