Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
ALTER TABLE products ADD COLUMN ram INT GENERATED ALWAYS AS (attributes->'$.ram') STORED, ADD INDEX idx_ram (ram); -- Now this query uses the index SELECT name FROM products WHERE ram = 16;
Result
Open