Email Note - Included in order purchase

[Shades]

The Email Note - Included in order purchase...is there a way to edit that globally like in phpadmin? I need them all to say the same thing for all products but I don't want to have to go into each item to edit cause that will take forever!

[SMFHacks]

Yes
UPDATE smf_store_item SET emailnote = "note goes here";

[Shades]

Thank you Thank you Thank you!
That just saved me hours of editing!

[Shades]

Yes
UPDATE smf_store_item SET emailnote = "note goes here";

So I could ultimately do that for any one of the fields in phpadmin? Like if I wanted to change the price of all to the same?

UPDATE smf_store_item SET price = "30.00"; ?

[SMFHacks]

Yes you can.

[Shades]

Is there a way to globally change certain phrases or words in the description without changing the whole description in phpadmin?

[SMFHacks]

yes https://www.w3resource.com/mysql/string-functions/mysql-replace-function.php

update tablename set columnname = REPLACE(columnname, "find_string", "replace_with")

[Shades]

Thanks, I will give that a go on my test site because I'm sure I'll screw something up!