Why am I getting this result from this search query?
The sql is:
lect * from calendar where description LIKE '%investigation%' or short_name LIKE '%investigation%' AND date>='2015-08-20' AND date<='2015-08-22' group by event_id order by date
The result I get is an event that happened from 2015-06-30 to 2017-07-08. Seems like that wouldn't be a viable "return" on the above statement in that I've qualified the range of dates to be between August 20th and August 22nd.
What am I doing wrong?
lect * from calendar where description LIKE '%investigation%' or short_name LIKE '%investigation%' AND date>='2015-08-20' AND date<='2015-08-22' group by event_id order by date
The result I get is an event that happened from 2015-06-30 to 2017-07-08. Seems like that wouldn't be a viable "return" on the above statement in that I've qualified the range of dates to be between August 20th and August 22nd.
What am I doing wrong?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You only have one date field in your query.