Can Sphinx be used to transfer products between MySql (MariaDB) tables?

Question

MySQL

I have a question for MySql and Sphinx connoisseurs (I'm not a programmer, but a simple user):
I want to use sphinx in the project in order to use less muscle, and so: is it possible to use sphinx to search for products in 1 table and, after finding a match, move the found product in 3 other tables and delete this product from 1 table?
And in general, should I use sphinx for such needs or work with memory? I have a VPS with 2 gigs of RAM.

Answer 1

Sphinx is only a search engine, it can only search, there are no inserts and delits in it and never will be.
Index your table.
Looking for post ids in sphinx.
Pass them to the backend.
do whatever you want with them.
And in general, should I use sphinx for such needs or work with memory? I have a VPS with 2 gigs of RAM.
And do you understand what you are asking? What does memory and the sphinx have to do with it?

Answer 2

you can search, you can
also move yourself

Answer 3

1. from table A, extracting a phrase, it is processed according to some pregmath condition
2 this phrase is searched for in table B, and the data in table B is also pre-processed according to some pregmath condition
3. the search (comparison) of these preprocessed phrases is of interest