| |
|
|
| | Ó ìåíÿ åñòü âîò òàêîé çàïðîñ
SELECT * FROM post WHERE allsite != '1' ORDER BY id DESC LIMIT 200
|
Êàê ìíå íàïèñàòü åãî ïðèìåðíî òàêîãî ïëàíà INTERVAL 5 DAY
Òî åñòü âûâåñòè âñå äàííûå çà ïîñëåäíèå 5 äíåé
Äàòà õðàíèòñÿ â datetime 2008-03-21 14:12:00 | |
| |
|
|
| |
|
|
| |
äëÿ: sayber
(23.04.2008 â 16:54)
| | | Âðîäå ñäåëàë - åñëè íå ïðàâèëüíî ñêàæèòå
SELECT * FROM post WHERE date > date_sub(now(),interval '6' day) ORDER BY id DESC LIMIT 200
|
| |
| |
|
|
| |
|
|
| |
äëÿ: sayber
(23.04.2008 â 17:09)
| | | Âñ¸ ïðàâèëüíî, êàê àëüòåðíàòèâà, ìîæíî èñïîëüçîâàòü îïåðàòîðû ïëþñà è ìèíóñà
SELECT * FROM post
WHERE date > now() - interval '6' day
ORDER BY id DESC
LIMIT 200
|
| |
| |
|
|
