Home | About | FAQ | Links | Feedback

Enter MySQL script (temp tables/CRUD allowed, 5 sec / 5MB / 20 rows max):

create table messages (id int, message varchar(100)); insert messages values ( 1 , 'One tow three' ), ( 2 , 'No error in this' ), ( 3 , 'My testing message' ), ( 4 , 'php module test' ), ( 5 , 'hello world' ), ( 6 , 'team spirit' ), ( 7 , 'puzzle game' ), ( 8 , 'social game' ), ( 9 , 'stackoverflow' ), (10 , 'stackexchange' ); create table messages2 select * from messages; set @variableHere = 2; Select * from messages Where id >= (Select id - @variableHere from messages2 where message like '%hello%') Order by id Limit (@variableHere * 2) + 1 Execute | Make Permalink (permalink: 3Q9z45906z) Sample 1 | Sample 2

No results are displayed if 5 second timeout reached.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(@variableHere * 2) + 1' at line 5

Need help with this error message? Check the FAQ.