Skip to content

Instantly share code, notes, and snippets.

@kazeburo
Created January 13, 2015 03:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kazeburo/f2fb1b38b946fbc4ddd6 to your computer and use it in GitHub Desktop.
Save kazeburo/f2fb1b38b946fbc4ddd6 to your computer and use it in GitHub Desktop.
mysql>select * from article_index_0005 where blog_id=6333476 and match public_terms against ('レース' IN BOOLEAN MODE)\G
~~~
~~~
*************************** 16. row ***************************
id: 476798
blog_id: 6333476
article_id: 1017522405
status: 1
public_terms: 7594e912ba60ac9e78c9008d1332ecd9 75362b350d0c24305205a50f791987db 2015/1/13 和歌山記念決勝 買いに行くつもりが寝坊しました。 <div> <div>武田でつまらない
レースになるんでしょうかね? <div> <div>安いので止めようと思いましたが記念にので簡単に買います。 <div> <div>1=23-23 <div> <div>安くても仕方ない。 <div> <div>明日から2連
休だし痛みも最小に。 <div> <div> <div> <div>昨日の当たらなすぎて重体からの投稿
private_terms:
regist_datetime: 2015-01-13 11:25:07
created_on: 2015-01-13 11:32:46
16 rows in set (0.00 sec)
mysql>select * from article_index_0005 where blog_id=6333476 and article_id=1017522405;
Empty set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment