List:General Discussion« Previous MessageNext Message »
From:Gelu Gogancea Date:August 29 2002 5:07pm
Subject:Re: like problem
View as plain text  
Hi,

Mary gives you a sugestion about how can you use field(b.name) in this case.
You can try this :
select a.name from table1 a, table2 b where a.name like
CONCAT('%',b.name,'%');

Regards,

Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY

Permanent e-mail address : gg@stripped
                                          gelugogancea@stripped
----- Original Message -----
From: "Jorge Martinez" <c00233@stripped>
To: "Mary Stickney" <mary.stickney@stripped>; <mysql@stripped>
Sent: Thursday, August 29, 2002 7:48 PM
Subject: RE: like problem


> yes, but select a.name from table1 a, table2 b where a.name like
> '%'b.name'%';
>
> is an error
>
>
> ----- Original Message -----
> From: Mary Stickney <mary.stickney@stripped>
> To: Jorge Martinez <c00233@stripped>; <mysql@stripped>
> Sent: Thursday, August 29, 2002 1:26 PM
> Subject: RE: like problem
>
>
> >
> > that would be because b.name is inside the ' ' and it is taken as a
> > constant.
> >
> >
> > -----Original Message-----
> > From: Jorge Martinez [mailto:c00233@stripped]
> > Sent: Thursday, August 29, 2002 11:10 AM
> > To: mysql@stripped
> > Subject: like problem
> >
> >
> > i need this consult
> >
> > select a.name from table1 a, table2 b where a.name like '%b.name%';
> >
> > but i have a problem because Mysql not recognize the value of b.name
> >
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> >    http://www.mysql.com/manual.php   (the manual)
> >    http://lists.mysql.com/           (the list archive)
> >
> > To request this thread, e-mail <mysql-thread118368@stripped>
> > To unsubscribe, e-mail
> > <mysql-unsubscribe-mary.stickney=tagtmi.com@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> >    http://www.mysql.com/manual.php   (the manual)
> >    http://lists.mysql.com/           (the list archive)
> >
> > To request this thread, e-mail <mysql-thread118372@stripped>
> > To unsubscribe, e-mail
> <mysql-unsubscribe-mailings=mivadi.com@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread118374@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-ggelu=arctic.ro@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
mysqlhotcopy problem - Segmentation faultMihail Manolov29 Aug
  • Mysql on a separate server from webserverNestor29 Aug
    • Re: Mysql on a separate server from webserverDavid Bordas29 Aug
    • RE: Mysql on a separate server from webserverAdam Nelson29 Aug
  • Re: mysqlhotcopy problem - Segmentation faultJeremy Zawodny29 Aug
  • Re: mysqlhotcopy problem - Segmentation faultMihail Manolov29 Aug
  • like problemJorge Martinez29 Aug
    • RE: like problemMary Stickney29 Aug
      • RE: like problemJorge Martinez29 Aug
        • RE: like problemMary Stickney29 Aug
          • RE: like problemJorge Martinez29 Aug
        • Re: like problemJed Verity29 Aug
          • RE: like problemJorge Martinez29 Aug
      • Re: like problemGelu Gogancea29 Aug