I couldn't find a real answer anywhere so I am asking.
Here is my query
("SELECT * FROM messages WHERE message_date < ? AND message_date //not greater than// ? AND to_user = ? OR from_user = ? ORDER BY message_date DESC")
I have no idea how to check that the date is not greater than the defined date
There's two ways to write it.
One option is to simply use <= since "not greater than" is equivalent to "less than or equal to."
The other is to use the NOT modifier, e.g. ... AND NOT (message_date > ?).
x<=y is even eqivalent to NOT(x>y) if either argument can be null.'Not greater than' is the same as saying 'less than or equal to', so:
SELECT * FROM messages
WHERE message_date < ? AND message_date <= ? AND to_user = ? OR from_user = ?
ORDER BY message_date DESC
You just need to check if it is less, but if you want to say not, you can use not!
not(message_date > ?)
new Date valid in MySQL?
?maybe you want like this,
SELECT *
FROM messages
WHERE message_date <= ? AND
? IN (to_user, from_user)
ORDER BY message_date DESC
when you say not greater than, it just means less than or equal to
? IN (to_user, from_user) may not be equivalent to ? = to_user OR ? = from_user (although it is in a considerable amount of use-cases).
<statement at the beginning of the query. For some reason it is showing things that are>the date that I have set.. Instead of only showing items that are<the defined date it is also showing items from>too and I cannot figure out why, this is why I asked the question. I hope that clarifies that my questions isn't entirely moronic.