Как удалить первый символ media_path в таблице article_media?

Question

[Lavrov95]

UPDATE `article_media`
SET `media_path` = RIGHT(`media_path`, LEN(`media_path`) - 1)

FUNCTION db.LEN does not exist

Answer 1

[Rsa97]

RTFM

Answer 2

[Mikhail Kupriyanov]

UPDATE article_media SET media_path = SUBSTR(media_path, 2);