Sorry. I am using Navicat for the first time and until you asked I didn't realise the error said more than just "error: you have an error in your SQL". However, clicking on this I realised the full error is:
error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MEDIUMTEXT),'"/>',`fulltext`)
WHERE images, `fulltext` NOT NULL' at line 2
Sorry for the omission. Definately appreciate your help.
Fantastic! Thanks for your patience r937, I have figured the mysteries of the manual!
I have got this to run to run:
SET `fulltext` = CONCAT('<img src="/images/stories/',CAST(images AS CHAR),'"/>',`fulltext`)
WHERE images IS NOT NULL
It updated the 500+ rows with images for me. Fantastic.
I wasn't able to get the "WHERE images AND `fulltext` IS NOT NULL" to work however as zero rows were updated for some reason. Have read several pages in the manual on the use of NULL and IS NOT NULL but can't find the issue with the two.