Is it possible to write a SQL query of the type "Select table From DBname Where date > '2017-02-11'"? If so, how is it right to form it?

  • stackoverflow.com/questions/8334493/… dev.mysql.com/doc/refman/8.0/en/tables-table.html - Vladimir Klykov
  • thank. partially helped by this SELECT table_name FROM information_schema.tables WHERE table_schema = 'your_database_name'; but how can I finish the query now, so that it only issues the table, where is date> '2017-02-11'? - Ledd
  • Look at the second link, what do you mean by date? creature? change? in fact, the second link describes the contents of the information_schema.tables table - Vladimir Klykov

1 answer 1

 SELECT * FROM yourtable WHERE datacolumn BETWEEN "2008.11.01" AND "2009.10.12"

As an example. If the field format is exactly date.