1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
| SELECT
id,
user_cid,
phone,
name,
CASE
gender
WHEN '1' THEN
'男'
WHEN '2' THEN
'女'
END AS gender,
start_city,
end_city,
story,
create_time
FROM
active_collection_story
WHERE
create_time BETWEEN '2019-01-25 00:00:00'
AND '2019-01-27 23:59:59';
|