How to remove specific rows from MySQL?

Question

MySQL

Good afternoon, help me solve the following problem, there is a site on OpenCart 1.5.5.1. many cards (approximately 80%) have the following text in the description at the end:
Volume: 0.0049 m3
Weight: 1 kg
Where only weight without volume can be registered, and somewhere there is no such data in all. There are about 5,000 cards, you understand, manually is not an option. Maybe somehow you can definitely make a request in MySQl or something else, please tell me.

Answer 1

It is quite possible to carry out proofreading of all records with one request. But for this you need to understand the structure of the table, make a backup, create a query, execute it and check the correctness of the result.
Without experience it is better not to do it yourself.