SQL query

[psn]

i use php and mysql.

i had stored a huge number of date in mysql database. Example 06/13/2004(mm/dd/yyyy).

i want to select all fields from database based on month and year. Day(dd) doesnt matter

Therefore i had queried
"Select * from table where date = '$month/**/$year'"
but it doesnot works.

So which is the correct query.

Values for $month and $year are retrived from customer who can enter this values in textboxes. thanks

[drew010]

SELECT * FROM table WHERE date LIKE '$month/__/$year'

that might work, give it a try. in mysql and means any 1 character, and a % is a wildcard for any number of characters, for example select all users with the first letter of their last name as D
select from names where last_name like 'D%'
or
select from names where last_name like 'D__'
would select all users with a 4 letter last name beginning with d.

[bretticus]

what type is your date field? are you really using the asterisks?

UPDATE: whoops, looks like drew010's got ya covered. He's probbly correctly assumed that your date field is not of type date but a string field too. 😃

[Sxooter]

You should really switch to using a date field here, as it allows things to be much simpler, like so:

select * from table where datefield between '2005-01-01' and '2005-01-31'