Using select

From: cruiserweight <bayon86_at_yahoo.com>
Date: 22 Dec 2004 02:14:50 -0800
Message-ID: <1103710490.871959.154010_at_f14g2000cwb.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:14:50 CET

Original text of this message