Skip to content
Advertisement

I am struggling to remove the last 30 characters from data in a column

I am looking to remove the last 30 characters from a colum within my database.

I have created the below which works in the sense it shows me the result and it’s correct but it does not commit or change anything.

What am I missing, I am a noob 🙂

I expect the data in the column to remove the last 30 characters from each row.

Advertisement

Answer

You need to use update statement:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement