问题描述
你好，环顾四周这似乎不是一件容易的事情，但是有没有办法识别表格&他们的列名有9个连续的数字？
Hello, looking around this doesn't appear to be an easy thing to do but is there a way to identify Tables & their Column names that have 9 consecutive digits?
例如，如果一个列的定义是varchar（50），并且它们是一个123456789的条目，它可能是一个SSN记录。
For example if a Column's definition is varchar(50) and their was an entry of 123456789 in it which could potentially be an SSN record.
如果在整个数据库中识别SSN条目或列的任何其他方法，请分享。
Please share if any other methods in identifying SSN entries or columns throughout a DB.
提前致谢。
推荐答案
在你的情况下，模式将是[0-9] [0-9] 9次（例如，你需要为你的目的略微修改那篇文章的代码）
In your case the pattern will be [0-9][0-9] 9 times (e.g. you would need to slightly modify code of that article for your purpose)
这篇关于在DB中查找SSN数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！