NYCPHP Meetup

[Ophir Prusak]

I think the plus symbol only works as an arithmetic operator to do addition.


On Tue, 16 Nov 2004 12:04:37 -0500, DeWitt, Michael
<mjdewitt at alexcommgrp.com> wrote:
> Ophir,
> 
> Yup.  Works like a charm.  Funny that the '+' concatentation character
> doesn't work the same way.
> 
> Mike
> 
> 
> 
> > -----Original Message-----
> > From: Ophir Prusak [SMTP:prusak at gmail.com]
> > Sent: Tuesday, November 16, 2004 12:00 PM
> > To:   NYPHP Talk
> > Subject:      Re: [nycphp-talk] MySQL query question
> >
> > This should work (if you want full substring search).
> >
> > select count(*) from table where company like concat('%',last_name,'%')
> >
> > On Tue, 16 Nov 2004 11:08:18 -0500, DeWitt, Michael
> > <mjdewitt at alexcommgrp.com> wrote:
> > > Does anyone know if there is a way to write a query in a v3 engine to do
> > a
> > > query comparing two columns using like?
> > >
> > > I would like to count all rows where the last name appears in the
> > company
> > > name.
> > >
> > > In sql server a query like this works:
> > >
> > > select count(*) from table where company like rtrim(last_name)+'%'
> > >
> > > Thanks in advance.
> > >
> > > Mike
> > >
> > > _______________________________________________
> > > New York PHP Talk
> > > Supporting AMP Technology (Apache/MySQL/PHP)
> > > http://lists.nyphp.org/mailman/listinfo/talk
> > > http://www.newyorkphp.org
> > >
> > _______________________________________________
> > New York PHP Talk
> > Supporting AMP Technology (Apache/MySQL/PHP)
> > http://lists.nyphp.org/mailman/listinfo/talk
> > http://www.newyorkphp.org
> _______________________________________________
> 
> 
> New York PHP Talk
> Supporting AMP Technology (Apache/MySQL/PHP)
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.newyorkphp.org
>