Essentially what I want to do is this:  SELECT Id, Email FROM User WHERE Email in ('first.last1%','first.last2%')   I am using this in a trigger and would like to come up with a query to match users based on the email prefix. Ideally, I like to avoid using a loop since I'm trying to avoid governor limits.  Anyone have a solution to this?
Is there a way to mix LIKE operator with IN ? Something Like  SELECT Id FROM Account WHERE Name LIKE IN:nameList   Where nameList is list of String? Is this is possible ? (I can make a dynamic query by doing OR with all the elements, but was looking for a more elegant way to do this)
How to report that a question should be migrated to another site? Seeking feedback on downvoted question? I try to understand why for a connected Lie group $G$ the first fundamental group $\pi_1(G)$ is abelian, and mainly why the second fundamental group is trivial $\pi_2(G)=0$?  Thanks for anyone who give me references for a 'simple proof' of these results I received a journal paper for a review. The paper suggests a solution to an important problem, but the solution is very complicated and has mediocre performance. While reading the paper, I thought of a different solution, which is much simpler and has better performance (to give some scale: their solution is 1 page to write and 5 pages to prove; my solution is 5 lines to write and half a page to prove).  What should I do now?  A. Write my solution in the review, hoping the authors will remember to "thank the anonymous reviewer"?  B. Recommend that the paper published as is, then write a paper of my own with my improved solution?  C. Something else?  EDIT: Before I found the superior solution, I thought of recommending "resubmit with major revision", with the reasons that I mentioned above: your solution is too complicated and its performance is too weak.  However, now I am not sure it is the good course of action. A major revision may take a long time. The authors might even decide to delay or stop working on the paper without telling the editor (or me). Meanwhile, I will have to postpone the publishing of the superior solution for an indefinite amount of time. What do you think? How to write a function (piecewise) with bracket outside? How to write this Piecewise function using LaTeX?  I tried $ \begin{array}{cc}   \{ &amp;      \begin{array}{cc}       0 &amp; x\leq 0 \\       \frac{100-x}{100} &amp; 0\leq x\leq 100 \\       0 &amp; 100\leq x     \end{array} \end{array} $  but it didn't work perfectly, the bracket &quot;{&quot; looks small, see: (This is on NT based Windows like 2000, XP, Vista, 7)  On the command-line, the percentage characters are ignored:  wget "http://www.justitie.nl/images/Handleiding%20voor%20verwerkers%20persoonsgegevens_tcm34-3940.pdf"   So it correctly downloads this file (each %20 becomes a space):  "http://www.justitie.nl/images/Handleiding voor verwerkers persoonsgegevens_tcm34-3940.pdf"   But inside a batchfile, all the %20 are being interpreted as expanding parameter 2 (which is empty) resulting in this file to get downloaded (each %20 becomes 0):  "http://www.justitie.nl/images/Handleiding0voor0verwerkers0persoonsgegevens_tcm34-3940.pdf"   Is there a way to circumvent the percentage parameter expansion?  --jeroen What are sentences like "the longer X, the more Y" called and can they be used in formal written English? What is the type of sentence exemplified below called? Is it appropriate to use it in a scientific paper and formal written English in general?     1. The more pronounced the variation, the   more the waste.      2. The more you give, the more you get.      3. The longer I live, the more I realize the impact of attitude on life. Find the center of the symmetry group $S_n$. Find the center of the symmetry group $S_n$.   Attempt:  By definition, the center is $Z(S_n) = \{ a \in S_n : ag = ga \forall\  g \in S_n\}$. Then we know the identity $e$ is in $S_n$ since there is always the trivial permutation. Suppose $a$ is in $S_n$, but not equal to identity. Now we can imagine the permutation as bijective function that maps from $\{1,2,\dotsc,n\}$ to $\{1,2,\dotsc,n\}$.  So suppose $p$ is a permutation map. Then $p$ maps from a location $i$ to a location $j$. Take $p(i) = j$ where $i\neq j$. Let $k$ be in $\{1,2,\dotsc,n\}$, where $k$, $i$ and $j$ are all different elements. The cycle $r = (jk)$, then we will see if this commutes.  $rp(i) = rj$    Can someone please help me, I am stuck?  Thank you. Show that $\left| \frac{1}{x}-\frac{1}{z} \right| \le \left|\frac{1}{x} - \frac{1}{y} \right| + \left|\frac{1}{y} - \frac{1}{z} \right|$. Let’s take an example of a movie site. So a well structured set of URLs for this site can be:     Movie page - example.com/movies/the-matrix Review for movie - example.com/movies/the-matrix/reviews Trailers for movie - example.com/movies/the-matrix/trailers Specific trailer for movie - example.com/movies/the-matrix/trailers/trailer1   where it’s possible to navigate the resource even by directly deleting/appending resource name seamlessly.  For SEO purpose I read somewhere that for two given pages, Google will prefer the page which have search query up in the URL hierarchy among other things. So for the given 2 URLs and the query "the matrix trailer"    example.com/movies/the-matrix/trailers example.org/trailers/the-matrix/    `     Google might prefer the second URL as it has the keyword "trailer" at first level comparing to first URL which has "trailer" at 3rd level (a resource deeper in URL hierarchy may be less important).    If it is correct, one may be tempted to create URL hierarchy somewhat like      Movie page - example.com/movies/the-matrix Review for movie - example.com/reviews/the-matrix/ Trailers for movie - example.com/trailers/the-matrix/ Specific trailer for movie - example.com/trailers/the-matrix/trailer1     which will break the seamless hierarchy.    My questions are:   Is it true that resource deeper in URL hierarchy is tend to be less important when comparing to URLs of other site?   Is sacrificing meaningful, seamless hierarchy worth for this SEO optimization? Induction: Prove that $4^{n+1}+5^{2 n - 1}$ is divisible by 21 for all $n \geq 1$. Induction: Prove that $4^{n+1}+5^{2 n - 1}$ is divisible by 21 for all $n \geq 1$. How does passive perception work Total noob question, but the passive perception is confusing. I don't understand how to calculate it or use it, and I need help. In the first book, Harry sees his Gringotts vault for the first time.  (Quotes thanks to Slytherincess!)     Griphook unlocked the door. A lot of green smoke came billowing out, and as it cleared, Harry gasped. Inside were mounds of gold coins. Columns of silver. Heaps of little bronze Knuts.      "All yours," smiled Hagrid.      All Harry's -- it was incredible. The Dursleys couldn't have known about this or they'd have had it from him faster than blinking. How often had they complained how much Harry cost them to keep? And all the time there had been a small fortune belonging to him, buried deep under London.      Hagrid helped Harry pile some of it into a bag. "The gold ones are Galleons," he explained. "Seventeen silver Sickles to a Galleon and twenty-nine Knuts to a Sickle, it's easy enough. Right, that should be enough fer a couple o' terms, we'll keep the rest safe for yeh."      Harry Potter and the Sorcerer's Stone - pages 58-59 - US Hardcover Edition   Jk Rowling posts in the Harry Potter Lexicon      JKR has stated in an interview (Comic Relief 2001) that she estimates the value of one Galleon to be "about five pounds," which works out to around US$9.75 (the exchange rate at the time of the interview was US$7.33). In the introduction to both QA and FB, US$250-million is stated to be the equivelent of 34 million Galleons. That also works out to a value of £5 to the Galleon, at the exchange rate of the time. The price listed on the back of the books, however, is not correct, since US$3.99 would equal less than half a British pound, or 8 sickles and 15 knuts. The book instead incorrectly lists US$3.99 as being equal to 14 sickles and 3 knuts. (Unfortunately, CNN.com uses this incorrect value for their Knuts-to-dollars converter.)      This gives us approximate values as follows:      1 bronze Knut = £0.01 (US about 2 cents)      1 silver Sickle = £0.29 (about US$0.57)      1 Galleon = £5.00 (more or less US$9.75)      These rates vary as the exchange rate fluctuates - see the Wizarding World Currency Converter for the current rate.   Now looking at the quote      Hagrid helped Harry pile some of it into a bag.   and     Right, that should be enough fer a couple o' terms, we'll keep the rest safe for yeh.   Obviously "some" is unspecified, but presuming the costs of ...     Typical elementary-school textbooks cost more than $100 each   He would be carrying at least 10 galleons for each school book, and going by the list of books just for his first year,  (Thanks Ibid!)     COURSE BOOKS      All students should have a copy of each of the following:         The Standard Book of Spells (Grade 1) by Miranda Goshawk   A History of Magic by Bathilda Bagshot   Magical Theory by Adalbert Waffling   A Beginners’ Guide to Transfiguration by Emeric Switch   One Thousand Magical Herbs and Fungi by Phyllida Spore   Magical Drafts and Potions by Arsenius Jigger   Fantastic Beasts and Where to Find Them by Newt Scamander   The Dark Forces: A Guide to Self-Protection by Quentin Trimble         (Harry Potter and Philospher's Stone, Chapter 5)   That's 80 Galleons just for books. This does not include the list of other expenses Harry has for his school years (wand, potion reagents, etc.)  How many Galleons is "some" or is Diagon Alley selling supplies for third world prices?  Sidenote, is this just a case of bad JK maths? Schengen visa permit I am a student with a Singapore passport currently studying in the Czech Republic for a semester. My permit is valid until 2nd of February, I plan to fly to the UK to travel for 3 days before heading back to Singapore from there.  Would there be any problems, such as exit immigration from the Czech Republic to the UK? I searched online that the UK is not part of Schengen Area Agreement states, and my passport has a visa free entry to the UK. I would like to port Ubuntu Touch to a device that is currently not supported. What are the requirements for doing this and where do I begin? Invoking Java main method with parameters from Eclipse During development (and for debugging) it is very useful to run a Java class' public static void main(String[] argv)  method directly from inside Eclipse (using the Run As context menu).  Is there a similarily quick way to specify command line parameters for the run? What I do now is go to the "Run Dialog", click through the various settings to the tab where I can specify VM and program arguments and enter them there.  Too many steps, plus I do not want to mix the more permanent runtime configuration settings with the one-off invokation parameters. What I want instead is to check a box somewhere (or have a separate menu item "Run as Java application with command line") and then be prompted for the commandline every time (with a nice history). There is a question I have based on the fact: If you take a quadratic polynomial with integer coefficients, take the set $\{1,2,3,4,5,6,7,8\}$, make a partition $A=\{1,4,6,7\}$, $B=\{2,3,5,8\}$, and then evaluate the polynomial with the elements of each set you got an equality.  If now with a cubic polynomial and the set $\{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16\}$, how to pick a suitable partition that accomplish the same fact? I mean is there a general formula for bigger degree? I know it is defined as $ dP \wedge dx  $ or explicitly,  $$ \frac{\partial P }{\partial y } dy \wedge dx   . $$  The question is, could it be $dx \wedge d P $?  Or  $$  \frac{\partial P }{\partial y }  dx \wedge dy ?    $$  I know the question must be very naive or even stupid. But I am indeed confused. I am trying to find a good rough guesstimate of how much of the maximum wattage usage of a graphics card is turned into hot air.  Say a graphics card is rated at using X watts at maximum usage. How much of that is released as heat into the air via the cooling setup, and how much is not (If not where does it go? To ground?)  Yes I know there are a lot of variables here, I am just looking for a guesstimate from someone who would understand better than me. I'm specifically using  (Radeon 6990 375 watts max) GRUB does not detect Windows I have finally installed Ubuntu on my second drive. When I start my computer GRUB only offers me to boot Ubuntu, not Windows 7. What needs to be done so that I can choose between Ubuntu and Windows in GRUB?  When I press F12 for boot menu at startup and I choose Windows Boot Manager it boots into Windows 7.    I ran command sudo fdisk -l and here is log ():  WARNING: GPT (GUID Partition Table) detected on '/dev/sda'! The util fdisk doesn't support GPT. Use GNU Parted.   Disk /dev/sda: 1000.2 GB, 1000204886016 bytes 255 heads, 63 sectors/track, 121601 cylinders, total 1953525168 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 4096 bytes I/O size (minimum/optimal): 4096 bytes / 4096 bytes Disk identifier: 0xc3ffc3ff     Device Boot      Start         End      Blocks   Id  System /dev/sda1               1  1953525167   976762583+  ee  GPT Partition 1 does not start on physical sector boundary.