Re: Using select
Date: Wed, 22 Dec 2004 14:16:43 GMT
Message-ID: <flfyd.8858$yK.579_at_newsread3.news.atl.earthlink.net>
"cruiserweight" <bayon86_at_yahoo.com> wrote in message
news: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
>
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