Greg is a retired neurologist in Louisville, Kentucky, with a long-standing interest in computers and programming, beginning with Fortran IV in the 1960s. When Linux and open source software came along, it kindled a commitment to learning more, and eventually contributing. He is a member of the Scribus Team.
Greg Pittman
Louisville, KY
Authored Comments
Apparently, there is a problem with trying to enter the greater than sign.
One thing about date (at least in Postgreql, and I assume similar in mysql), is that, even though it looks like a string in the command line, you can use inequalities, such as:
select * from test where date > '2021-12-31' and date '2023-01-01';
This will get you all the items dated somewhere in 2022.