识别年错误
问题描述:
嗨
我有一个sql表,我想查找不正确输入年份的记录,即输入1999作为19999的输入错误和类似的例子.
Hi
i have an sql table, i want to find the records where year is entered improperly ie 1999 is entered as 19999 the typing error and similar examples
答
正则表达式以实现tat.
可以通过在create语句中提供表达式来检查表达式.
You can go for regular expressions to achieve tat.
Can check the expression by providing it in the create statement its will do tat.
Select * from tablename where not datecolumn between '1900/1/1' and '2011/12/29'