create table scores
(id int, userid int, score decimal(6,2), tags varchar(50), datestamp date)
;
insert into scores
(id, userid, score, tags, datestamp)
values
( 1 , 1 , 10 , 'keyword1,keyword2', '2012-12-06 03:55:16') ,
( 2 , 1 , 50 , 'keyword2,keyword3', '2012-12-06 04:25:21') ,
( 3 , 1 , 20 , 'keyword2,keyword1', '2012-12-06 04:35:33') ,
( 4 , 2 , 5 , 'keyword2, keyword1', '2012-12-06 04:55:45') ,
( 5 , 2 , 10 , 'keyword2,keyword3,keyword1', '2012-12-06 05:25:11') ,
( 6 , 2 , 12 , 'keyword1,keyword2,keyword3', '2012-12-06 05:55:21') ,
( 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') ,
(10 , 1 , 10 , '', '2012-12-07 06:45:16') ,
(11 , 1 , 5 , '', '2012-12-07 06:27:16') ,
(12 , 1 , 20 , '', '2012-12-07 08:33:16') ,
(13 , 2 , 15 , '', '2012-12-07 09:25:19') ,
(14 , 2 , 10 , '', '2012-12-07 13:33:16') ,
(15 , 2 , 5 , '', '2012-12-07 15:45:44') ,
(16 , 3 , 10 , '', '2012-12-07 16:05:16') ,
(17 , 3 , 20 , '', '2012-12-07 18:33:55') ,
(18 , 3 , 5 , '', '2012-12-07 18:42:11')
;
select * from scores WHERE (tags LIKE '%易筋經%' OR tags LIKE '%吸星大法%');
CmNyZWF0ZSB0YWJsZSBzY29yZXMKKGlkIGludCwgdXNlcmlkIGludCwgc2NvcmUgZGVjaW1hbCg2LDIpLCB0YWdzIHZhcmNoYXIoNTApLCBkYXRlc3RhbXAgZGF0ZSkKOwppbnNlcnQgaW50byBzY29yZXMKKGlkLCB1c2VyaWQsIHNjb3JlLCB0YWdzLCBkYXRlc3RhbXApCnZhbHVlcwooICAxICAJLAkxCSwJMTAJLAkna2V5d29yZDEsa2V5d29yZDInLCAnMjAxMi0xMi0wNiAwMzo1NToxNicpCSwKKCAgMiAgCSwJMQksCTUwCSwJJ2tleXdvcmQyLGtleXdvcmQzJywgJzIwMTItMTItMDYgMDQ6MjU6MjEnKQksCiggIDMgIAksCTEJLAkyMAksCSdrZXl3b3JkMixrZXl3b3JkMScsICcyMDEyLTEyLTA2IDA0OjM1OjMzJykJLAooICA0ICAJLAkyCSwJNQksCSdrZXl3b3JkMiwga2V5d29yZDEnLCAnMjAxMi0xMi0wNiAwNDo1NTo0NScpCSwKKCAgNSAgCSwJMgksCTEwCSwJJ2tleXdvcmQyLGtleXdvcmQzLGtleXdvcmQxJywgJzIwMTItMTItMDYgMDU6MjU6MTEnKQksCiggIDYgIAksCTIJLAkxMgksCSdrZXl3b3JkMSxrZXl3b3JkMixrZXl3b3JkMycsICcyMDEyLTEyLTA2IDA1OjU1OjIxJykJLAooICA3ICAJLAkzCSwJMjAJLAkn5ZC45pif5aSn5rOVIOaYk+eti+e2kycsICcyMDEyLTEyLTA2IDEzOjU1OjE2JykJLAooICA4ICAJLAkzCSwJMTAJLAkn5bCR5p6X5piT562L57aT5piv5LiA56iu5YGl6Lqr55uu55qE5Y2B5YiG5piO56K655qE5q2m6KGT5aWX6Lev44CCJywgJzIwMTItMTItMDYgMTQ6NTU6MTYnKQksCiggIDkgIAksCTMJLAk1CSwJJ+aYk+eti+e2kyDlkLjmmJ/lpKfms5UnLCAnMjAxMi0xMi0wNiAxNTo1NToxNicpCSwKKDEwICAgCSwJMQksCTEwCSwJJycsICcyMDEyLTEyLTA3IDA2OjQ1OjE2JykJLAooMTEgICAJLAkxCSwJNQksCScnLCAnMjAxMi0xMi0wNyAwNjoyNzoxNicpCSwKKDEyICAgCSwJMQksCTIwCSwJJycsICcyMDEyLTEyLTA3IDA4OjMzOjE2JykJLAooMTMgICAJLAkyCSwJMTUJLAknJywgJzIwMTItMTItMDcgMDk6MjU6MTknKQksCigxNCAgIAksCTIJLAkxMAksCScnLCAnMjAxMi0xMi0wNyAxMzozMzoxNicpCSwKKDE1ICAgCSwJMgksCTUJLAknJywgJzIwMTItMTItMDcgMTU6NDU6NDQnKQksCigxNgkgICAgLAkzCSwJMTAJLAknJywgJzIwMTItMTItMDcgMTY6MDU6MTYnKQksCigxNwkgICAgLAkzCSwJMjAJLAknJywgJzIwMTItMTItMDcgMTg6MzM6NTUnKQksCigxOAkgICAgLAkzCSwJNQksCScnLCAnMjAxMi0xMi0wNyAxODo0MjoxMScpCQo7CQkJCQkJCQpzZWxlY3QgKiBmcm9tIHNjb3JlcyBXSEVSRSAodGFncyBMSUtFICcl5piT562L57aTJScgT1IgdGFncyBMSUtFICcl5ZC45pif5aSn5rOVJScpOwo=