mysql - Modify the isbn data of the database so that if the isbn encoding is normal, it will not change. If it exceeds 13 digits, the first 13 digits will be taken directly. How should I write the sql statement?

Question

Answer 1

Query: select substr(isbn,0,13) from table

Modification: update table set isbn = substr(isbn,0,13)