I have a database table db.content with fields db.content.message, db.content.description and db.content.tags. i have another field db.personal.mytags and the keywords a user puts in db.personal.mytags doesn't change. i want to create a view where a user will see only information in db.content.message only IF the keywords in db.personal.mytags can be found in db.content.message or db.content.description or db.content.tags.
the logic is to loop through db.content and check if keywords in db.personal.mytags are in db.content.message or db.content.description or database.content.tags, if so, that row in db.content is selected... so that if there's 20 rows in db.content and there's only 6 of the 20 rows that have some content with the keywords in db.personal.mytags, the user sees only content from those 6 rows... how do i achieve this? --
