help needed with database calculations
right i have 3 columns one it an item name the other is a weight and the last is a refference
i need to be able to add a number to the item name and for it to be applies to the weight
for instance all the weights are filled out by our cart system apart from some direct sales we do where there is no weight inputted we need a way for it to search for a number withing qoutation marks or something im not sure.
see we can edit the item name on our cart just not input a custom weight and the thing is they will always be custom
so sometimes it can be 250g or it could be 734g
look forward to hearing back from you thankyou