I try this, and still did work:
SELECT product, indications FROM product p WHERE
p.indications LIKE "cool%"
but this work
LIKE "%cool%", but I only want indications begins w/
cool.
--- Jayson Garrett <[EMAIL PROTECTED]> wrote:
> I notice that in this example, you have the table
> and a column with the
> same name ("product"). That could potentially be
> causing a problem, if
> that's really how those items are named. In any
> case, it's certainly
> confusing.
>
> Long Huynh wrote:
> > That's what I thought, but it returns nothing. I
> even
> > try it in the sqlite manager.
> > The real syntex is
> > "SELECT * FROM product WHERE product LIKE "abc%"
> >
> > What have I done wrong?
> >
> > --- Mathieu Langlois <[EMAIL PROTECTED]>
> wrote:
> >
> >
> >> I guess it depends on what x and y are, but that
> >> form seems valid to me.
> >>
> >> On 7/17/06, Long Huynh <[EMAIL PROTECTED]>
> wrote:
> >>
> >>> Why does not this work?
> >>> SELECT * FROM x WHERE y LIKE 'abc%'
> >>>
> >>>
> >> _______________________________________________
> >> Unsubscribe or switch delivery mode:
> >>
> <http://www.realsoftware.com/support/listmanager/>
> >>
> >> Search the archives of this list here:
> >>
> >>
> >
>
<http://support.realsoftware.com/listarchives/lists.html>
> >
> >
> > _______________________________________________
> > Unsubscribe or switch delivery mode:
> > <http://www.realsoftware.com/support/listmanager/>
> >
> > Search the archives of this list here:
> >
>
<http://support.realsoftware.com/listarchives/lists.html>
> >
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
>
> Search the archives of this list here:
>
<http://support.realsoftware.com/listarchives/lists.html>
>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
