Is there a way I could create a variable that belongs to a table much like a static variable belongs to a class? So it "thing=1, person=2" were variables belonging to the table structure (not each row), then I could do something like this:
SELECT *
FROM table
WHERE type = table.thing OR type = table.person
I haven't touched sql in months, and I have a feeling this is something very simple.