I need to make a search engine that searches for keywords in my database. I have a word field where I keep all the keywords I want for the product.
For example I have a product with keywords 'red shirt', I need the user to put those words in the search box like this or the other way around 'red shirt' and look for all those that match those two specifically.
The truth is that I have no idea how to make the query, so I do not put any sentence, I'm using mysql. If you can help me to make the query or to see how to structure the database to make that query, I would thank them: D
Edit This is the structure of the table, in the field marked with red is where I keep the keywords and with that I want to ask the question
