fork download 
  1. CREATE TABLE game_lists (
  2.   `name` VARCHAR(20) NOT NULL,
  3.   `desc` VARCHAR(20) NOT NULL);
  4.  
  5. INSERT INTO game_lists ('test', 'description'), ('name', 'description'), ('name', 'test');
  6.  
  7. SELECT * FROM game_lists WHERE MATCH (`name`,`desc`) AGAINST ('test')
Runtime error #stdin #stdout #stderr 0s 2964KB
comments (?)
stdin 
Standard input is empty
stdout 
Standard output is empty
stderr 
Error: near line 5: near ",": syntax error
Error: incomplete SQL: SELECT * FROM game_lists WHERE MATCH (`name`,`desc`) AGAINST ('test')
https://ideone.com/gDiMCz
language:
SQLite (sqlite 3.27.2)
created:
10 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!