How to prevent incorrect saving of text to DB in MySQL?

Question

MySQL

There is a link like product&path=82_214&product_id=4763&limit=10000
When saving it to the database, it is saved as
product&path=82_214&product_id=3372&limit=10000
How to make amp; was not added next to & ?

Answer 1

Offtopic of course, but do you know what SQL injection is?
Well, in general, when pulling back from SQL, perform the reverse operation. php.net/manual/ru/function.htmlspecialchars.php - how it goes.
php.net/manual/ru/function.htmlspecialchars-decode.php - how to return back.
If you do not have php, then just google analogues.