Re: Using select

From: David Cressey <>
Date: Wed, 22 Dec 2004 14:16:43 GMT
Message-ID: <flfyd.8858$>

"cruiserweight" <> wrote in message
> 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

Tony asked a good question. Have you tried the following?

SELECT * FROM photos WHERE product like 'RWS1981035W00025-01F%' Received on Wed Dec 22 2004 - 15:16:43 CET

Original text of this message