Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
CREATE TABLE articles ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255), body TEXT, FULLTEXT(title, body) ); -- Or add to existing table ALTER TABLE articles ADD FULLTEXT idx_search (title, body);
Result
Open