need SQL statment that will change all of the cc_number

[spencermjax]

I need an SQL statment that will change all of the cc_number in the orders table to XXXXXXXXXXXX1234.

 

I need the 1st 12 numbers of each card number to be changes to 'XXXXXXXXXXXX' and leave the last 4 digits.

 

I have a masking script already installed but I need to go back and update all past orders. Doing it one by one is killing me.

[germ]

I found this:

 

Credit Card numbers cleaner

 

I don't know anything about it other than it exists....

[♥geoffreywalton]

Try w3.schools.com and google

 

Words to look for are

 

UPDATE

SET

concat

right

[arietis]

I need an SQL statment that will change all of the cc_number in the orders table to XXXXXXXXXXXX1234.

 

I need the 1st 12 numbers of each card number to be changes to 'XXXXXXXXXXXX' and leave the last 4 digits.

 

I have a masking script already installed but I need to go back and update all past orders. Doing it one by one is killing me.

 

1. backup your database.

 

2. try:

update orders set cc_number = concat('xxxxxxxxxxxx', substr(cc_number, 13, 4));

[jfo9696]

and where would i put that code

[arietis]

and where would i put that code

 

use phpmyadmin.

[♥stubbsy]

Have you tried this...

 

http://addons.oscommerce.com/info/1072

 

Validated the Credit Card, and want to remove it from the database, but keep the customers order history intact ?

 

Card Zapper, lets you xxxxx out the card number of any order you choose !

 

Helps to make things a bit more secure.

[spencermjax]

Stubbsy,

The card zapper contribution is a very nice one. I have several hundred and did not want to go through one by one though. Thanks.

 

arietis,

Thanks!!! your statment worked like a charm.