Forum Moderators: open

Message Too Old, No Replies

Mysql Query

         

artie2004

10:35 pm on Mar 5, 2007 (gmt 0)

10+ Year Member



hi. i have the following mysql table.

TABLE transactions
(
transactions_id int,
transactions_account_num int,
transactions_amount double,
transactions_date datetime
)

how do i query all rows for the current year only? thanks.

coopster

10:44 pm on Mar 5, 2007 (gmt 0)

artie2004

12:00 am on Mar 6, 2007 (gmt 0)

10+ Year Member



thanks coopster. i remember that. i just didn't know how to search for my old post.

coopster

5:03 pm on Mar 6, 2007 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



No problem, I thought the question/author looked familiar ;)

I searched on the keywords using the forums site search [webmasterworld.com] found at the top of the page.