下面是我正在使用的JSON: {
"featured": [
{
"name": "Featured Show number 1",
"id": "123",
"slug": "featured-show-number-one",
"description": "This is an item description for show number 1"
},
{
所以我的查询如下:
SELECT TIMEDIFF('24:00:00',(TIMEDIFF('22:00:00',TIME(end)))) AS time
FROM sworkingtime
WHERE user='magdalena' AND type='work' AND start BETWEEN '2014-03-01' AND '2014-03-28' AND (HOUR(`end`) > 22 OR HOUR(`end`) < 4)
AND completed=1
我的查询
我在我的Web应用程序中有以下结构,使用了"encoding/json“
type CourseAssignment struct {
Semester int `json:"semester" xml:"semester"`
Lecture Lecture `json:"-" xml:"-"`
Cos Cos `json:"-" xml:"-"`
Links map[string][]Link `json:"links,omitempty