select * from nama_tabel where DATE_FORMAT(nama_field,%Y-%m-%d)>=2009-05-25? and DATE_FORMAT(nama_field,%Y-%m-%d)<=2009-05-30?