2008-05-13から1日間の記事一覧
select * from book where create_date >= '2007/12/05 10:00:00' AND create_date <= '2008/05/12 10:00:00';
select * from book where now() - interval '3 month' <= create_date;
SELECT kb_user.pt <-> hot_spring.pt as distance, hot_spring.name as spring, place.name as place FROM kb_user, hot_spring, place WHERE kb_user.name = 'shokai' and place.area ~ hot_spring.pt ORDER by distance asc;