Why don't you have the option to pick things that fall into multiple categories?
What I mean is, you have a "categories" page that hast stuff like "Asian," "Blowjobs," "Big Tits," etc, but on the page you just click one.
Why not make it a checkbox thing where you can check off a bunch of different categories and then search for the videos that are grouped into all of those categories?
Could be a pretty handy SQL query: SELECT * FROM VIDEOS WHERE CATEGORY="ANAL" AND CATEGORY = "BIG_TITS";
Alternatively, maybe you don't like Asians, but you like blowjobs and you check that you don't want them.
SELECT * FROM VIDEOS WHERE CATEGORY = "BLOWJOBS" AND CATEGORY != "ASIANS";
It's just something I've always wondered. No porn sites do this and it doesn't seem like it would be hard to implement.
EDIT 2:I get it. It's a reddit comment, not my databases 101 final. I don't know their DB schema, either. I appreciate it, though. I've never been a DB guy.
TheWizardOfMagicLand2884 karma
Why don't you have the option to pick things that fall into multiple categories?
What I mean is, you have a "categories" page that hast stuff like "Asian," "Blowjobs," "Big Tits," etc, but on the page you just click one.
Why not make it a checkbox thing where you can check off a bunch of different categories and then search for the videos that are grouped into all of those categories?
Could be a pretty handy SQL query: SELECT * FROM VIDEOS WHERE CATEGORY="ANAL" AND CATEGORY = "BIG_TITS";
Alternatively, maybe you don't like Asians, but you like blowjobs and you check that you don't want them.
SELECT * FROM VIDEOS WHERE CATEGORY = "BLOWJOBS" AND CATEGORY != "ASIANS";
It's just something I've always wondered. No porn sites do this and it doesn't seem like it would be hard to implement.
EDIT: Thanks, guys.
EDIT 2: I get it. It's a reddit comment, not my databases 101 final. I don't know their DB schema, either. I appreciate it, though. I've never been a DB guy.
View HistoryShare Link