StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
11481007
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-07-14T04:21:50.343
FavoriteCount
0
LastActivityDate
2012-07-14T04:29:58.530
LastEditDate
2012-07-14T04:29:58.530
LastEditorUserId
107744
OwnerUserId
107744
ParentId
11480841
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
The simplest explanation is that you have only a single "year" column in your table. (We may be mistakenly implying (from the references to "year_1" and "year_2" in your question) that your table has two separate "year" columns you are wanting to check.) If you have only one "year" column that you are checking, then it's pretty simple query: <pre><code>SELECT p.* FROM persons p WHERE p.year >= $year_1 AND p.year <= $year_2 </code></pre> But your question seems to reference two separate columns: year_1 and year_2, in addition to your two variables $year_1 and $year_2. So, another possible interpretation of the spec is that the year_1 and year_2 columns are lower and upper bounds of a continuous range, and you want to find rows that satisfy an entire given range of years. As an example, year_1 might be "birth year" and year_2 might be "death year", and I am wanting to find all rows from the persons table who were "alive" EVERY year in a given range: <pre><code>SELECT p.* FROM persons p WHERE p.year_1 <= $year_1 AND p.year_2 >= $year_2 </code></pre> (I don't think this is what you're asking, but I'm not sure.) Another possible interpretation is that I want to find anyone that was "alive" during ANY (but not necessarily all) years in a given range. I'd get that with a query like: <pre><code> SELECT p.* FROM persons p WHERE p.year_1 <= $year_2 OR p.year_2 >= $year_1 </code></pre> Or, I may be asking a fundamentally different question, looking for an event year during particular range of years. Like I want to find anyone that was either "born" or that "died" in a given range of years... <pre><code> SELECT p.* FROM persons p WHERE p.year_1 >= $year_1 AND p.year_1 <= $year_2 OR p.year_2 >= $year_1 AND p.year_2 <= $year_2 </code></pre> But again, it's not clear from your question which (if any) of those result sets you actually want to return.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POFetch values from mysql database between year_1 and year_2
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USspencer7593
UserOwnerUserId
1. USspencer7593
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.