Hi everyone, I would like to ask a question about MySQL. Say, I have a database like this:
database 1:
articles
|- id
|- title
|- description
database 2:
tags
|- id
|- articleID
|- tag
I needed to search from articles.description and tags.tag and while doing so, the searched articles should get the tag from the tags table and the searched tags should get the description from the arcticles.
displaying them as:
title | description | tags
I'm not really sure how to do this yet as I am not an expert when it comes to MySQL. An answer will be greatly appreciated.
TIA