Quote:
Originally Posted by lakerslive
Hello,
i have a custom DB.
It has a table structure called "POST"
in that table POST it has a field called "TAGS" where data like
blonde, brunette, MILF, fit, busty etc.. are all stored.
My question is, is the database structured correctly to enable a filter system on the front end to do a combine tag filter search? example, i only want "BLONDES" with "FIT" bodies? thank you!
|
Without knowing much more:
Select * from tablename where tags like '%blondes%' and tags like '%fit%'
Should work. How well it works depends on your indexing.
I have my models db structured with a models table and a tags table.
The tags table has the model_id and a tag name and there are multiple tag records per model.
.