Filter combining tags

[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!

[sarettah]

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.

.