SQLize Online / PHPize Online  /  SQLtest Online

USE test_operations; INSERT services(id, code, category, status, type, number, logo, description, info) VALUES (NULL, 'TEST', 'taxi', 'active', 'simple', 1000, NULL, 'TEST', 'TEST'); ALTER TABLE services MODIFY COLUMN logo TEXT; UPDATE `services` SET `logo` = CONCAT('"url:"', logo, '"name:"', 'SUBSTRING(logo, LENGTH(logo) - POSITION(' / ', REVERSE(logo)) + 2, LENGTH(logo))', '"isGenerated:"', '"true"') WHERE logo IS NOT NULL;