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>

Reply via email to