StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POmysql force order of results found to match order of IN clause
primarykey
Id
5471399
data
AcceptedAnswerId
5471491
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-03-29T10:57:02.830
FavoriteCount
0
LastActivityDate
2011-03-29T11:04:25.047
LastEditDate
2017-05-23T11:55:25.687
LastEditorUserId
-1
OwnerUserId
177132
ParentId
0
PostTypeId
1
Score
0
ViewCount
322
LastEditorDisplayName
text
Body
This question is different to a <a href="https://stackoverflow.com/questions/4986731/how-to-select-mysql-rows-in-the-order-of-in-clause">commonly asked question</a> about ordering the final results by the IN clause. I would like to force the results returned by the query that contains the IN clause, to match the order of the IN clause. <a href="https://stackoverflow.com/questions/5461743/combining-mysql-queries-that-recycle-multiple-self-joins">This is the original question</a> that I am working from. I'd like to alter the query below so that a row containing <code>progress=2</code> occurs before <code>progress=4</code> and <code>progress=7</code> for each <code>session_id</code> when ordering the <code>formation_page_hits</code> table by <code>datetime</code>. Here is the current query: <pre><code>SELECT COUNT(*) FROM ( SELECT session_id FROM formation_page_hits WHERE progress IN (2, 4, 7) AND datetime >= '2011-03-23' AND datetime < '2011-03-24' GROUP BY session_id HAVING COUNT(DISTINCT progress) = 3 ) q </code></pre> These entries <pre><code>datetime, session_id, progress ('2011-03-01 01:02:11', 'abc', 2) ('2011-03-01 01:02:12', 'abc', 4) ('2011-03-01 01:02:13', 'abc', 7) </code></pre> should be a match for the query, but: <pre><code>datetime, session_id, progress ('2011-03-01 01:02:11', 'abc', 4) ('2011-03-01 01:02:12', 'abc', 2) ('2011-03-01 01:02:13', 'abc', 7) </code></pre> should not be a match. Additionally: <pre><code>datetime, session_id, progress ('2011-03-01 01:02:11', 'abc', 4) ('2011-03-01 01:02:12', 'abc', 2) ('2011-03-01 01:02:13', 'abc', 4) ('2011-03-01 01:02:14', 'abc', 7) </code></pre> should be a match.
Tags
<mysql><order>
Title
mysql force order of results found to match order of IN clause
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USJon
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. CO(2, 4, 7) is strictly ascending order. Is your example data special or you want always to use ascending order?
 singulars
 PostPostId
 POmysql force order of results found to match order of IN clause
 UserUserId
 USvbence

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.