I need to order the results by how the values in IN() clause are set up, here is the example code.  SELECT nickname, age WHERE id IN(3, 1, 2) ORDER BY ?; &lt;- this is where I need the results go back according to the IN() clause   This the result as of now, (using PHPmyadmin, not yet php coded).  nickname | age | true id of the row j        | 11  | 1 jj       | 22  | 2 jjj      | 33  | 3   The result that I need is:  nickname | age | true id of the row jjj      | 33  | 3 j        | 11  | 1 jj       | 22  | 2   Can I do this with using IN() clause? This is the only idea that I came up with so if you have any idea/s that I may try then please tell me.
I am wondering if there is away (possibly a better way) to order by the order of the values in an IN() clause.  The problem is that I have 2 queries, one that gets all of the IDs and the second that retrieves all the information. The first creates the order of the IDs which I want the second to order by. The IDs are put in an IN() clause in the correct order.  So it'd be something like (extremely simplified):  SELECT id FROM table1 WHERE ... ORDER BY display_order, name  SELECT name, description, ... WHERE id IN ([id's from first])   The issue is that the second query does not return the results in the same order that the IDs are put into the IN() clause.  One solution I have found is to put all of the IDs into a temp table with an auto incrementing field which is then joined into the second query.  Is there a better option?  Note: As the first query is run "by the user" and the second is run in a background process, there is no way to combine the 2 into 1 query using sub queries.  I am using MySQL, but I'm thinking it might be useful to have it noted what options there are for other DBs as well.
In Visual Studio, How do I show all classes inherited from a base class?    For example, in ASP.NET MVC there are several '' types -- and they all inherit from / implement the base class ActionResult.    It looks like unless you just 'know' that View and Json are valid ActionResult types, there is no way you can easily find this information out.    Please prove me wrong.  Is there something in the object browser that makes this easy to find out?  I'm even up for suggestions of tools outside of Visual Studio to discover this information about various classes.  For example: is there something in Resharper that will help me out? How does DC work with natural 20? How do I summon a baby mob? In Minecraft Java Edition, one can summon baby zombies and drowned using the IsBaby NBT tag: /summon zombie X Y Z {IsBaby:1b}  Likewise, one can summon baby breedable mobs (Pigs, Cows, etc.) by giving them a negative Age NBT tag (the number of ticks until the mob grows up): /summon cow X Y Z {Age:-100000}  Since NBT is inaccessible from commands in Bedrock Edition, the above commands will not work there. How do I summon baby mobs in Minecraft Bedrock Edition? Is there ever a right time to upgrade to full frame camera body? Context  I've been shooting with an a6000 (APS_C mirrorless) and I plan to move on up to full frame, preferably mirrorless as well. I'm debating on when to upgrade, and probably don't plan to buy until next year.  I know I'll need to buy new full frame lens.  Question  Is there a "right" time to buy camera bodies, both mirrorless in my case as well as DSLRs? (I've seen the a7rII and like it but there might also be an a9 looming.) I feel that this is like smartphones in which the best time to buy is now as you might always be waiting until the next upgrade.   Related, are full frame bodies discounted during the holiday season or is that limited only to entry level bodies and older full frame bodies?  Related It's often the case that I want to change name servers because my site is messed up.  Well, it takes a very long time for the name server to propagate.  Is there something in DNS, or registrar or anything I can do to speed that up.  Flushing my dns server using  and it rarely works I use this command in the terminal to run the minecraft launcher with java 8:  /home/max/Java/jre1.8.0_25/bin/java -jar Minecraft.jar   I included the full java path because I installed it on /home as a normal user and i want to include it.   That command works, it opens the launcher with Java 8 but I want to make a bash file so I don't have to open the terminal. And, most important, I don't want the terminal to remain open when I click play in the Minecraft launcher and the game starts.  Now if i close manually the terminal when the game have started, the game is closed too. I'm searching for applications where the distribution of the eigenvalues of a unitary matrix are important. Example properties of the eigenvalues could be that the eigenvalues are clustered, that they live in some half plane, that, in the case that the matrix is orthogonal, that a certain fraction are 1, etc. How can number of subdirectories and files be determined from the output of using ls -ld command?  I realize that this command only lists the directories. In the , the icon color for the various sites seems* incorrect: Whenever I select a main site, the icon is greyed out, and when ever I select the corresponding meta site, the icon is colored. My initial instinct was to think that the colors of the main/meta sites following the &quot;Switch sites:&quot; prompt should be switched. (Actually, it seems like it's just a UI thing. See the edit below.)  *Edit: Actually, the colors are technically not incorrect, since (as Jeremy Banks has pointed out) the icon shows &quot;the other&quot; site of the main/meta pair, and clicking on it is for switching to the respective other site. See the comment thread for some UI improvement ideas. When to use Path in WPF Binding? Many SE sites (like math.SE) have a problem with mixed content, which causes display bugs in recent browsers. This is particularly evident with math.SE (because of the huge use of MathJax) and with chat sections.  Will this be fixed?  How to reproduce  Visit  or   What happens  Mixed content is blocked, output is missing pieces of code (MathJax):    This picture also includes my main Firefox addons (top right), it relevant. It shows missing styles:    The white on the left is my tab list. Join CSV file to shapefile What decides what to prepend the duplicate question list with on a duplicate question? On duplicate questions, I often see different headings for the duplicate question list. These include:     Possible Duplicate:    [duplicate question list]   and      This question already has an answer here:    [duplicate question list]   and more recently,     This question is an exact duplicate of:    [duplicate question list]   What decides which heading is placed before the duplicate question list? Electric circuits in TeX, LaTeX, and Friends How to set root password to null Find $\lfloor {\alpha}^6 \rfloor$ If $\alpha$ is a real root of the equation   $$x^5-x^3+x-2=0$$   find the value of $\lfloor {\alpha}^6 \rfloor$.      This one totally stumped me. We are asked to calculate $\lfloor {\alpha}^6 \rfloor$ without actually calculating the root or using wolfram alpha or any other calculator. I found that the above equation has only one real root by sketching its graph using calculus. I was also able to use the intermediate value theorem to conclude that $1&lt;\alpha&lt;2$ , but this is of little use while calculating $\lfloor {\alpha}^6 \rfloor$. Please help! If $n\ne 4$ is composite, then $n$ divides $(n-1)!$. Since Newton's law of gravitation can be gotten out of Einstein's field equatons as an approximation, I was wondering whether the same applies for the electromagnetic force being the exchange of photons. Is there an equation governing the force from the exchange of photons? Are there any links which would show how the Coulomb force comes out of the equations for photon exchange? I know that my question is somewhat similar to the one posted here , but it doesn't really have an answer to my question specifically. Traveling to the US with new passport, visa on the old one Functions vs. patterns