[PHP-MYSQL] Aggiornamento di testo su db

[nicola75ss]

prova così

SELECT *,
CONCAT(
LTRIM(SUBSTRING(body from IF (INSTR(body,'[i]'),LENGTH(body)-LOCATE('>', REVERSE(body))+1,0 )+1)),' ',
SUBSTRING(body,1,IF (INSTR(body,'[i]'),LENGTH(body)-LOCATE('>', REVERSE(body))+1,0 ))
)
from news2