Mysql CONCAT help please

[pasher]

Well, I think its the CONCAT I need ......

The 'products' table contains a field called 'product_image', which contains the image file - xxxx.jpg, yyyy.gif etc.

Now, I've sucessfully imported 11000 rows into this table from another database, using EasyPopulate, but the imported image files are without the extension (.gif), so I need to add that to cells that don't have it.

So, a mysql command to do this, please -

ie. if text in cell does not contain a '.', append '.gif' to the text. Do this for the whole 'products_image' column.

Any takers?

Thanks
Pa

[DrByte]

update products set products_image = concat(products_image, '.gif') where products_image not like '%.%' and products_image != '';

[pasher]

That looks good.
Thanks DB