Save json inside a Symfony migration

Question

I have an Item entity which have an "access" field, typed as json, that is added through a migration. I'm trying to add also values in the table I'm editing, and fill this field, but I can't find the correct syntax. Currently I'm trying to do something like $this->addSql(<<<SQL INSERT INTO `item` (`id`, `name`, `description`, `progress`, `price`, `category`, `access`) VALUES ('3', 'Hyperboost', 'Fait avancer de 5 cases', '5', '2.5', 'personnal', [{"start": 65, "end": 100, "ranking": 'team'}]); SQL); JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

I think you just need single quotes $this->addSql(<<<SQL INSERT INTO `item` (`id`, `name`, `description`, `progress`, `price`, `category`, `access`) VALUES ('3', 'Hyperboost', 'Fait avancer de 5 cases', '5', '2.5', 'personnal', '[{"start": 65, "end": 100, "ranking": 'team'}]'); SQL);