SELECT *, date_add(campo, interval 1 month) as new_data
from tabella etc....