こういう検索ができるようになったんだけど需要あるかな。
クレーム殺到で問答無用で止められたりしないところに置ければいいんだけどなぁ。
mysql> select mail,dat,thread from mailhash inner join maru on mailhash.hash = maru.hash and mailhash.mail = '
[email protected]' limit 10;
+-------------------------+-----------------------------+----------------------+
| mail | dat | thread |
+-------------------------+-----------------------------+----------------------+
|
[email protected] | 2013/07/14(日) 09:31:17.66 | gamefight/1373756289 |
|
[email protected] | 2013/07/14(日) 09:32:15.61 | gamefight/1373756289 |
|
[email protected] | 2013/07/14(日) 09:34:52.87 | gamefight/1373761975 |
|
[email protected] | 2013/07/14(日) 09:36:22.50 | gamefight/1373761975 |
|
[email protected] | 2013/07/14(日) 09:37:02.48 | gamefight/1373761975 |
|
[email protected] | 2013/07/14(日) 09:41:04.82 | gamefight/1373761975 |
|
[email protected] | 2013/07/14(日) 09:58:25.58 | gamefight/1373761975 |
|
[email protected] | 2013/07/14(日) 10:00:16.06 | gamefight/1373761975 |
|
[email protected] | 2013/07/14(日) 10:00:53.75 | gamefight/1373761975 |
|
[email protected] | 2013/07/14(日) 10:01:24.98 | gamefight/1373761975 |
+-------------------------+-----------------------------+----------------------+
10 rows in set (0.02 sec)