Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    New York, NY
    Posts
    248

    SQL Code for Overwriting Credit Card Numbers

    Hello,

    I have a need to keep credit card information on one of my sites for a few days to process orders offline. Once ordered, I would like to blank out the credit card numbers. What would the SQL code be to change all credit card information in the table `orders` field `cc_numbers` to `11111111111111111` be?

    Thanks,
    Ian

  2. #2
    Join Date
    Mar 2006
    Posts
    418
    UPDATE `orders` SET `cc_numbers` = '11111111111111111' WHERE `order_id` = 'WhateverOrderIdItIs'

    assuming that the field you have which has the order id or whatever is named order_id
    || Semi-professional PHP developer || Exams right now, don't I just feel lucky? ||

  3. #3
    Join Date
    Jun 2003
    Location
    New York, NY
    Posts
    248

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •