5 Nov
2009
5 Nov
'09
8:59 p.m.
Actually tried it with the commas, same effect. On Nov 5, 2009, at 2:57 PM, Magnus Enger wrote:
2009/11/5 Erik Lewis <elewis@ngrl.org> Been playing with this for awhile
SELECT CONCAT('http://images.amazon.com/images/P/'isbn'.01.TZZZZZZZ.jpg') FROM isbn_experiment LIMIT 10;
I think you may need som commas in the parentheses:
SELECT CONCAT('http://images.amazon.com/images/P/', isbn, '. 01.TZZZZZZZ.jpg') FROM isbn_experiment LIMIT 10;
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat ;-)
Regards, Magnus Enger libriotech.no