PHWinfo - Afficher un message - Search for specific length string in column

16/09/2007, 06h20

>> I have a client that was allowing people to store credit card numbers in plain text, in an application. I need to rip through the table and replace every instance of credit card numbers with "x" and the last 4 digits. <<

You might want to learn the difference between a field and column
before you write anymore SQL -- like what a constraint is. I assume
that youmeant 16 digits, broken into groups of 4 digits.

UPDATE Foobar
SET creditcard_nbr
= 'xxxx-xxxx-xxxx-" + SUBSTRING( creditcard_nbr,13, 16);

Having done this, put all of this in the DDL. Mop the floor,but fix
the leak!!

16/09/2007, 06h20	#6
--CELKO-- Messages: n/a Hébergeur:	Re: Search for specific length string in column >> I have a client that was allowing people to store credit card numbers in plain text, in an application. I need to rip through the table and replace every instance of credit card numbers with "x" and the last 4 digits. << You might want to learn the difference between a field and column before you write anymore SQL -- like what a constraint is. I assume that youmeant 16 digits, broken into groups of 4 digits. UPDATE Foobar SET creditcard_nbr = 'xxxx-xxxx-xxxx-" + SUBSTRING( creditcard_nbr,13, 16); Having done this, put all of this in the DDL. Mop the floor,but fix the leak!!