I have a huge MySQL Database and i need you to write an script so i can easy change data inside my mysql database.
Here is the problem:
I have several rows and data inside these rows. For example:
Article Price Weight Shipping Remarks
Tool123 10 0 true test
Tool124 10 0 true test2
Tool125 12 0.9 true test1
Tool2123 13 0.5 false test
Tool3123 10 1 true
[url removed, login to view] 24 0 true test2
Tool9123 9 0 false
and so on
Now i want that i can change data by command for price. for example set a value. but the important is just to set an value or to edit current value if article ends with 123. I want that the scrit automatically looks for information inside one row and if this information is true than enter or edit data from a different row. this job is basically a "if and when" script.
if you can help me out write a short mail and name me by my name Reiko. I am not interessted in your projects which you have done in the past. no references need to be posted. i only check your freelancer feedback. if you have 0 feedbacks we wont work together. payment will be done after i am fully satisfied and your script work for my database.