Tirsdag 15. januar 2013 12.50.00 skrev Barbara Woolums : > I am running a query like so > > SELECT id FROM image WHERE image='demo-harvey wallbanger.jpg' > > It returns nothing > > My table looks like this > > "demo-820.jpg";1 > "demo-lemon-mousse-1.jpg";2 > "demo-pumpkinchaibars.jpg";3 > "demo-Lolly-Shop.jpg";4 > "demo-scan0001.jpg";5 > "demo-cherry-chocolate-mousse-pie.jpg";6 > "demo-harvey wallbanger.jpg > ";7
It seems like you've got a newline at the end of the first field of the last row. Does it work if you change the query to SELECT id FROM image WHERE image LIKE '%demo-harvey wallbanger.jpg%' ? regards, Leif -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql