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>