MySql query - need help please

changes in a field's table

[tito]

Hello,

please, i should change the text included into field 'common_descr' of the table 'myitems' of MySql 4.1.12

this text to be changed it will be the same for all items, so i guess i can run a query just to substitute the previous textA with the new textB into all fields named 'common_descr' of the table 'myitems'

is this possible? please can you suggest me how?

Thanks so much,
tito

[leadegroot]

simple - run an sql query along these lines:
UPDATE myitems SET common_descr = "new text";

Note this will update ALL of the rows in this table.

[moltar]

Just in case you get unexpected results, backup the database first.

[tito]

Thank You Leadegroot! i had no clue, i'm still a beginner.
Yes Moltar, backup always saved my day.

Cheers,
tito