SQL QUERY HELP - Joomla! Forum - community, help and support

help
i totally confused, i'm using dbq extensions try , administer database. use virtuemart offline credit card processing, meaning store cvv code until order processed. need delete number database reatin other information.

i informed dbq used write sql query delete number table (or replace 000). have no idea how sql queries built or operate.

the table called:

jos_vm_order_payment

with field being called:

order_payment_code

what need sql query delete / replace number in field. can help?

thanks

lee

always bit of worry advise amending database, here goes...

backup database

to able update data, must have unique field on select (you not want update records in database need use clause identify particular record). table should contain kind of id field - primary key, can use safely retreive 1 record.
here have called unique field
some_unique_id_field
you need in table find field name use.

code: select all

update jos_vm_order_payment set order_payment_code='000' some_unique_id_field='some-value';

to sure, can select record first (to view , see correct record)

code: select all

select * jos_vm_order_payment some_unique_id_field='some-value';

i not familiar virtuemart, guess may better update field 000 rather empty in case virtuemart code expecting value in there when access record later.