Just for you information FYI. A problem with your sql parser in the database facility

This sql query is checked in IntelliJ IDEA as non valid:

UPDATE frases SET autor1 = SUBSTRING(autor,1,11) WHERE autor LIKE "Caes. Gall.%";

The parser thinks "Caes. Gall.%" should be a column name. This query works without problem in mysql
command line.