I have a field called titulo
, in the noticias
table. Unfortunately, due to forgetting PHP's trim
command, it has several titles with space at the beginning and end of the string . How can I via SQL (MySQL) update the titles by removing spaces at the beginning and end, in a single SQL command?