fork download
copy 
  1.  
  2. create table scores
  3. (id int, userid int, score decimal(6,2), tags varchar(50), datestamp date)
  4. ;
  5. insert into scores
  6. (id, userid, score, tags, datestamp)
  7. values
  8. (  1  	,	1	,	10	,	'keyword1,keyword2', '2012-12-06 03:55:16')	,
  9. (  2  	,	1	,	50	,	'keyword2,keyword3', '2012-12-06 04:25:21')	,
  10. (  3  	,	1	,	20	,	'keyword2,keyword1', '2012-12-06 04:35:33')	,
  11. (  4  	,	2	,	5	,	'keyword2, keyword1', '2012-12-06 04:55:45')	,
  12. (  5  	,	2	,	10	,	'keyword2,keyword3,keyword1', '2012-12-06 05:25:11')	,
  13. (  6  	,	2	,	12	,	'keyword1,keyword2,keyword3', '2012-12-06 05:55:21')	,
  14. (  7  	,	3	,	20	,	'吸星大法 易筋經', '2012-12-06 13:55:16')	,
  15. (  8  	,	3	,	10	,	'少林易筋經是一種健身目的十分明確的武術套路。', '2012-12-06 14:55:16')	,
  16. (  9  	,	3	,	5	,	'易筋經 吸星大法', '2012-12-06 15:55:16')	,
  17. (10   	,	1	,	10	,	'', '2012-12-07 06:45:16')	,
  18. (11   	,	1	,	5	,	'', '2012-12-07 06:27:16')	,
  19. (12   	,	1	,	20	,	'', '2012-12-07 08:33:16')	,
  20. (13   	,	2	,	15	,	'', '2012-12-07 09:25:19')	,
  21. (14   	,	2	,	10	,	'', '2012-12-07 13:33:16')	,
  22. (15   	,	2	,	5	,	'', '2012-12-07 15:45:44')	,
  23. (16	    ,	3	,	10	,	'', '2012-12-07 16:05:16')	,
  24. (17	    ,	3	,	20	,	'', '2012-12-07 18:33:55')	,
  25. (18	    ,	3	,	5	,	'', '2012-12-07 18:42:11')	
  26. ;							
  27. select * from scores WHERE (tags LIKE '%易筋經%' OR tags LIKE '%吸星大法%');
  28.  
Success #stdin #stdout 0s 3360KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
7|3|20|吸星大法 易筋經|2012-12-06 13:55:16
8|3|10|少林易筋經是一種健身目的十分明確的武術套路。|2012-12-06 14:55:16
9|3|5|易筋經 吸星大法|2012-12-06 15:55:16
https://ideone.com/YvxASY
language:
SQLite (sqlite 3.27.2)
created:
9 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!