MySQL Forums
Forum List  »  Newbie

What's wrong with my query? Filter by date and email address
Posted by: Ryan Suzuki
Date: November 19, 2017 02:05AM

Hi all,
Please help. I'm looking for tickets that were received from a particular email address, submitted between a date range.

SELECT
email,
ticket_number,
ds
FROM
table
WHERE
email = 'xxxxx@gmail.com'
AND ds BETWEEN '2016-01-01'
AND '2016-11-01'
ORDER BY
ds ASC;

Shows no results even though it should. What am I missing here, did wrong here? please help, if not the right place, please redirect me. thanks. #NOOBS

Options: ReplyQuote


Subject
Written By
Posted
What's wrong with my query? Filter by date and email address
November 19, 2017 02:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.