Link to home
Create AccountLog in
Avatar of Richard
Richard

asked on

access update query

update query please

i have a column in dbse which contains some numbers say 1 22, 30 38

they may go up to 100 in due course or more
i want to devise a query that will change a group of them

say all the 10 s in the column to 12 or some other number of operators choice

help ppl
Avatar of lee555J5
lee555J5
Flag of United States of America image

What are those numbers -- "1 22, 30 38"?
Did you mean
1
22
30
38
etc.
?

If so, try this
UPDATE table_name
SET column_name = 12
WHERE column_name = 10;

Open in new window

Lee
ASKER CERTIFIED SOLUTION
Avatar of Richard
Richard

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Richard
Richard

ASKER

hit on it by chance!