hi there
Quick question. I have a table full of char(255) rows with plain text in them. I wish to search through for any instance of four or 16 digits, eg
1234 or 1234567812345678 or 1234-5678-1234-5678
(I'm trying to locate credit card numbers).
I'm a bit rusy on SQL. anyone suggest a select statement pls?
The field is called "thread_content_part"
Cheers
Dude
Quick question. I have a table full of char(255) rows with plain text in them. I wish to search through for any instance of four or 16 digits, eg
1234 or 1234567812345678 or 1234-5678-1234-5678
(I'm trying to locate credit card numbers).
I'm a bit rusy on SQL. anyone suggest a select statement pls?
The field is called "thread_content_part"
Cheers
Dude