Form a sql database?

Question

SQL

Good afternoon. I came across such a thing, give me an idea.
There is an xml unloading of goods, the formation of which is carried out through a search query. All new positions, when the page is loaded, are uploaded to the database in the background. But there is a problem, how to display it from the database later, if, for example, at the request of a dress, there are 100 products, and at the request of a mini-dress, 30 of the hundreds above are displayed, and I am looking for a search query recorded in the database.
It’s possible to split the query into words and search by them, but it’s also not an option, since there are more than 500 thousand products. Rewriting queries every time is also garbage, and if you leave it like that, then it won’t display for other queries.
Supplement the string with keys (is it possible?). Searching by name and description is not an option, since 50% of them do not contain keys. Tell me how to do all this? Although it seems to me that everything can be made simpler and I just got wildly confused for 3 hours already ...)
What I'm looking for: a way to structurally record positions in the database, in order to then perform an accurate search on them

Answer 1

I think as soon as you arrange in your head, the solution will immediately appear to
streamline, you can start with formatting and a clear formulation of the question

Answer 2

"There is an xml unloading of goods, the formation of which is carried out by means of a search query."
This is the key to your problem. Parse xml.