I have many posts that only have to store a couple of values (e.g. , 1, 2, 3). What datatype must i pick for this type of situation? I seem like I ought to pick something similar to ENUM('0', '1', '2'). Would int be superior (despite it being less limited)? Must I consider another thing (like tinyint)?
Really, what general advice must i consider when determining on the data type?
If you wish to restrict it to those 3 values, then indeed ENUM may be the best.
You can definitely, there's possible that later on, more values may be needed, then TINYINT UNSIGNED is most likely a much better solution.