Rails 查询的结果怎么按某种形式合并起来?

hexawing · March 06, 2013 · Last by tumayun replied at March 08, 2013 · 2369 hits

比如这样的一个表:

+----------+--------+-------------+
|   date   | event  | description |
+----------+--------+-------------+
| 2013.3.1 | event1 | aaaaaa      |
| 2013.3.1 | event2 | bbbbb       |
| 2013.3.1 | event2 | ccccc       |
| 2013.3.2 | event1 | dddd        |
| 2013.3.2 | event2 | eeeeeee     |
+----------+--------+-------------+

我想输出成这样的结果:

- 2013.3.1 * event1 + aaaaaa
* event2 + bbbbb
+ ccccc
- 2013.3.2 * event1 + dddd
* event2 + eeeeeee

不这样也行,只要能某种程度上的“合并”就行了,能实现吗?

查了一下,貌似是搞定了……谢谢 LS

group_concat

#3 楼 @tumayun 上次查的时候也看到了这个,谢谢指点!

You need to Sign in before reply, if you don't have an account, please Sign up first.