Using select
From: cruiserweight <bayon86_at_yahoo.com>
Date: 22 Dec 2004 02:17:52 -0800
Message-ID: <1103710672.786876.199490_at_z14g2000cwz.googlegroups.com>
This seems incredibly pedestrian, but I can't for the life of me figure it out.
Date: 22 Dec 2004 02:17:52 -0800
Message-ID: <1103710672.786876.199490_at_z14g2000cwz.googlegroups.com>
This seems incredibly pedestrian, but I can't for the life of me figure it out.
Looking with phpmyadmin, I have about 60 rows in a table called 'photos'. One of the fields is titled "product", which holds a photograph id like 'RWS1981035W00025-01F'. The product field is defined as varchar(25), as the length will vary from about 19 chars to 23.
When I run this query:
SELECT * FROM photos WHERE product = 'RWS1981035W00025-01F'
it returns no results, even though I can see it with my own eye, even if I copy bloody product id directly from a SELECT * FROM photos result set. Incredibly frustrating. What am I missing here? Thanks much in advance for any and all help.
Best
c Received on Wed Dec 22 2004 - 11:17:52 CET