MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Manuel Coral A. Date:September 8 1999 7:56pm
Subject:RE: select question
View as plain text  
 Hello again, 
 
 well some hours ago, I asked for  the problem described
 below, I guess this is obvious for the expert sql
 programers, but for me and for the new users  the fix
 was to put the statements as:
 
 select * from transactions where code="000058";
 
 since I defined the code field as varchar.
 
 Ok, at this moment I have another problem, my code
 values  ( from  the before table ) as values like 0000xx
 and 0000xx-y ( 000058 and 000058-1, 000058-2, and so on
 ), The thing I need to get is all the rows with the same
 0000xx regardless caracters after it, or more simple, I
 need to list with one select sentence 000058, 000058-1,
 000058-2, and so on...It is posible..?.. I was looking
 for the mailing list, and I belive that the fix will be
 using temporary tables... but.. I don't know how to use
 this at now, and post it for save some time, if someone
 can helpme .
 
 thanks in advance..
 
 Manuel Coral.
 
> 
> 
> Mensaje citado por: mysql@stripped:
> 
> > Hello again, my code columns type is varchar in both
> > cases, as I saw you, I don\\\'t have any problem if  the
> > code value is 58, but with 000058 I don\\\'t have any
> > result.
> > My mysql version 3.22.25, and I runing this on the
> Linux
> > slackware 2.0.34 kernel
> > 
> > Any sugestions are welcome
> > 
> > Manuel.
> > 
> > 
> > Mensaje citado por: sinisa@stripped:
> > 
> > > Manuel Coral A. writes:
> > >  > Hello guys,
> > >  > can some one tell me what is the difference
> betwen?
> > >  > 
> > >  > select * from transaction where code=000058;
> > >  > 
> > >  > and
> > >  > 
> > >  > select * from transaction where code=58;
> > >  > 
> > >  > ??
> > >  > 
> > >  > since I have in the  transaction table the code
> > value
> > >  > with numbers has 0000xx and  xx, and I don\\\\\\\'t
> get
> > >  > anything with the first sentence, and with the
> > second
> > >  > yes all is ok (of courser, I have another line
> with
> > the
> > >  > 58 code value different of 000058 code value line
> > ), I
> > >  > am a very new in the database world, some helps
> are
> > >  > welcome
> > >  > 
> > >  > Regards.
> > >  > 
> > >  > Manuel Coral.
> > >  > 
> > >  > 
> > >  > 
> > >  > 
> > > 
> > > 
> > > What kind of column type is code ??
> > > 
> > > And what version of Mysql are you running ??
> > > 
> > > Sinisa
> > > 
> > >
> >
> +----------------------------------------------------------------------+
> > > | TcX  ____  __     _____   _____  ___     == 
> > mysql@stripped            |
> > > |     /*/\\\\*\\\\/\\\\*\\\\   /*/ \\\\*\\\\ /*/ \\\\*\\\\ |*|    
> Sinisa
> > Milivojevic          |
> > > |    /*/ /*/ /*/   \\\\*\\\\_   |*|   |*||*|    
> > mailto:sinisa@stripped|
> > > |   /*/ /*/ /*/\\\\*\\\\/*/  \\\\*\\\\|*|   |*||*|    
> Larnaka,
> > Cyprus             |
> > > |  /*/     /*/  /*/\\\\*\\\\_/*/ \\\\*\\\\_/*/
> > |*|____                             |
> > > | 
> >
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\\\\*\\\\^^^^^^^^^^^                           
> > |
> > > |             /*/             \\\\*\\\\               
> > Developers Team       |
> > >
> >
> +----------------------------------------------------------------------+
> > > 
> > > 
> > 
> > 
> > -----------------------------------------------------
> > This mail sent through IMP: http://web.horde.org/imp/
> > 
> 
> 
> -----------------------------------------------------
> This mail sent through IMP: http://web.horde.org/imp/
> 

Thread
select questionManuel Coral A.7 Sep
  • Re: select questionsinisa7 Sep
    • Re: select questionManuel Coral A.8 Sep
      • Re: select questionMartin Ramsch8 Sep
RE: select questionManuel Coral A.8 Sep
  • Re: select questionRicardo T. Saito9 Sep
  • Re: select questionStefan Tryggvason9 Sep