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