Hi,
I finally found the solution
"SELECT count( smsc_id ) AS total, week( insertdate ) AS tanggal
FROM momtbak
WHERE insertdate
BETWEEN DATE_SUB( CURRENT_DATE( ) , INTERVAL 4 WEEK )
AND CURRENT_DATE( )
GROUP BY week( insertdate )"
Willy
--
MySQL General Mailing List
For list archives: http://
Hi, I have tried to use this query: "SELECT count(smsc_id) as total,
insertdate FROM momtbak WHERE insertdate BETWEEN
DATE_SUB(CURRENT_DATE(), INTERVAL 4 WEEK) AND CURRENT_DATE() group by
week(date_format(insertdate,'%Y-%m-%d'),3)" to group records in the
last 4 weeks by week. But the result re
com
Cc: sangprabv <[EMAIL PROTECTED]>
Subject: Re: Query to Select records in the last 4 weeks
Date: Wed, 03 Dec 2008 17:52:32 -0800
SELECT * FROM momtbak
WHERE insertdate
BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 4 WEEK) AND CURRENT_DATE();
--
MySQL General Mailing List
For list ar
On Thu, 2008-12-04 at 08:27 +0700, sangprabv wrote:
> Hi,
> I get stuck to build a query to select records between curdate() and the
> last 4 weeks and groupped by week. I tested with:
>
> "SELECT *
> FROM momtbak
> WHERE insertdate
> BETWEEN curdate( )
>
Hi,
I get stuck to build a query to select records between curdate() and the
last 4 weeks and groupped by week. I tested with:
"SELECT *
FROM momtbak
WHERE insertdate
BETWEEN curdate( )
AND curdate( ) - INTERVAL 4 week"
It doesn't work. Please help, TIA.
Willy
Every why h
On Tue, 24 May 2005 [EMAIL PROTECTED] wrote:
>Selon Dan Bolser <[EMAIL PROTECTED]>:
>
>>
>> Hello,
>>
>> I have data like this
>>
>> PK GRP_COL
>> 1A
>> 2A
>> 3A
>> 4B
>> 5B
>> 6B
>>
>I agree, especially with the additional information the OP provided about
>his REAL table structure. A separate groups table makes better sense.
>
>Let this be an object lesson to others looking for assistance: If you want
>timely and useful assistance, provide real and complete information
gt;PK GRP_COL
> >>1 A
> >>2 A
> >>3 A
> >>4 B
> >>5 B
> >>6 B
> >>7 C
> >>8 C
> >>9 C
> >>
> >>And I want to write a query to select data like this...
> >>
> >>PK
>>
> >>PK GRP_COL
> >>1 A
> >>2 A
> >>3 A
> >>4 B
> >>5 B
> >>6 B
> >>7 C
> >>8 C
> >>9 C
> >>
> >>
> >>And I want to write a query to select data like this...
[EMAIL PROTECTED] wrote:
Dan Bolser <[EMAIL PROTECTED]> wrote on 05/24/2005 06:08:32 AM:
Hello,
I have data like this
PK GRP_COL
1 A
2 A
3 A
4 B
5 B
6 B
7 C
8 C
9 C
And I want to write a query to select data like this...
PK FK GRP_COL
1 1 A
2 1 A
3
gt; PK GRP_COL
>> 1A
>> 2A
>> 3A
>> 4B
>> 5B
>> 6B
>> 7C
>> 8C
>> 9C
>>
>>
>> And I want to write a query to select data like this...
>>
>> PK FK GRP_COL
>> 11
is
PK GRP_COL
1 A
2 A
3 A
4 B
5 B
6 B
7 C
8 C
9 C
And I want to write a query to select data like this...
PK FK GRP_COL
1 1 A
2 1 A
3 1 A
4 4 B
5 4 B
6 4 B
7
Dan Bolser <[EMAIL PROTECTED]> wrote on 05/24/2005 06:08:32 AM:
>
> Hello,
>
> I have data like this
>
> PK GRP_COL
> 1 A
> 2 A
> 3 A
> 4 B
> 5 B
> 6 B
> 7 C
> 8 C
> 9 C
>
>
> And I want to write a query to sel
Hi,
try for axample,
select PK, ord(GRP_COL),COL from your_table;
Mathias
Selon Dan Bolser <[EMAIL PROTECTED]>:
>
> Hello,
>
> I have data like this
>
> PKGRP_COL
> 1 A
> 2 A
> 3 A
> 4 B
> 5 B
> 6 B
> 7 C
> 8
Hello,
I have data like this
PK GRP_COL
1 A
2 A
3 A
4 B
5 B
6 B
7 C
8 C
9 C
And I want to write a query to select data like this...
PK FK GRP_COL
1 1 A
2 1 A
3 1 A
4 4 B
5
Using MySQL 4.0.20, I need to extract just the numeric portion of a
string in a field and move it to another field in the same table, but
I'd only like to do this if the value actually starts with a number.
So, what I'm looking to accomplish is:
UPDATE table SET field2 = VOODOO( field1 )
The fi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 20 July 2003 22:59, Tanamon wrote:
> ++---+--+
>
> | id | file_name | max(version) |
>
> ++---+--+
>
> | 6 | ffour |2 |
> | 1 | fone |3 |
> | 5 | fthree|
Hello All,
I am a MySQL newbie trying to write a query that selects file_name records
possessing the highest numbered version for that unique file_name. I show
sample data and two trial queries below. Logically I want to use
max(version) as a constraint in a Where Clause. However, the max() fun
18 matches
Mail list logo
