New turn to navicat query a table of from January 1, 2001 to 2006 was born on December 31 of the personnel information fields as idcard table called in asking who taught a

CodePudding user response:

Select * from where a
Substr (idcard, 7, 8) & gt;=20010101 and substr (idcard, 7, 8) & lt;=20061231;