Is there a way to transform the data before I could query it?
MySQL strip non-numeric characters to compare
When I used  pip install ipython   or  pip install "ipython[notebook]"   I get the following error:  Downloading/unpacking ipython   Downloading ipython-2.3.1-py27-none-any.whl (2.8MB): 2.8MB downloaded Installing collected packages: ipython Cleaning up... Exception: Traceback (most recent call last):   File "/usr/lib/python2.7/dist-packages/pip/basecommand.py", line 122, in main     status = self.run(options, args)   File "/usr/lib/python2.7/dist-packages/pip/commands/install.py", line 283, in run     requirement_set.install(install_options, global_options, root=options.root_path)   File "/usr/lib/python2.7/dist-packages/pip/req.py", line 1435, in install     requirement.install(install_options, global_options, *args, **kwargs)   File "/usr/lib/python2.7/dist-packages/pip/req.py", line 671, in install     self.move_wheel_files(self.source_dir, root=root)   File "/usr/lib/python2.7/dist-packages/pip/req.py", line 901, in move_wheel_files     pycompile=self.pycompile,   File "/usr/lib/python2.7/dist-packages/pip/wheel.py", line 206, in move_wheel_files     clobber(source, lib_dir, True)   File "/usr/lib/python2.7/dist-packages/pip/wheel.py", line 193, in clobber     os.makedirs(destsubdir)   File "/usr/lib/python2.7/os.py", line 157, in makedirs     mkdir(name, mode) OSError: [Errno 13] Permission denied: '/usr/local/lib/python2.7/dist-packages/IPython'  Storing debug log for failure in /home/username/.pip/pip.log   What does this error mean? How do I fix it? Install Biber in MiKTeX on a 64-bit version of Windows Update: As of summer 2015 Biber is also included in the 64-bit repositories for MikTeX. There is no need to install Biber manually any more, it can simply be installed via the Package Manager just like other packages.   The question  describes how to use Biber with MiKTeX. But on the 64-bit version of MiKTeX Biber isn't installed.  How it is possible to install Biber on a 64-bit version of Windows?  Can I use this ? I am married to a UK citizen. What type of visa do I need to travel to the UK for tourism? I am a Bangladeshi citizen married with my husband who is a British citizen by birth. Currently, we both live in Bangladesh and my husband works at a university. We, are planning to visit UK for about 3 weeks. Just to be clear, we have no intention to settle down in the UK.  Do I need to apply for a visa? If so, then what type of visa should I apply for?  N.B. I've been searching on the internet (including the UK border agency website) for hours now but couldn't get a definite answer. Passport validity for Canada I am traveling from Boston to Canada by cruise ship. The first port of arrival is on July 30 and the last port in Canada is on August 4. Then I'm flying on August 5 from Montreal to California. My passport is valid until August 20th. Will I have a problem? As expected, Nvidia drivers have reduced my customizations. I can't login to Unity 3D session. I can't find any content to help me to uninstall the driver and I don't know what to do as I have never uninstalled them before. When compiling a beamer presentation and using the following \author command  \author{Name \\ \texttt{my.email@domain.com}}   I get the following hyperref warning in my logfile  Package hyperref Warning: Token not allowed in a PDF string (PDFDocEncoding): (hyperref)                removing `\\' on input line 15.   Package hyperref Warning: Token not allowed in a PDF string (PDFDocEncoding): (hyperref)                removing `\new@ifnextchar' on input line 15.   I understand that this has to do with hyperref setting the PDF metadata, where the linebreak does’t make much sense and should be removed.  Trying to set  \hypersetup{pdfauthor={Name}}   does’t change the situation, seems like hyperref is still looking at the author command.  How do I get the desired display of author name with email and still keep hyperref happy? Facebook changed how their API serves profile pictures that are requested with a non-application scope UID. Now because before Graph API 2 all applications shared the original UID, if users like me has joined Stack Exchange websites before  2, rolling out their profile pictures are not shown properly. Facebook suggests to use an access token to query those profile pictures, either an application access token or a user access token. A user access token is not a reliable option at all, because it would only work for users who joined website with Facebook and are currently logged in. Application access tokens, by the way, can be used by creating sort of a proxy that would retrieve a profile picture from Facebook and display it. Yet still it's not perfect. I think the best solution is to communicate with Facebook and ask them to offer an opportunity to convert old Graph API 1 UID's to application scope user IDs. Yes, the plot is pretty weird. There is this "star" (whose incarnation is a woman dressed in white) and some random guy who falls in love with her. There's the arc of "if you cross a specific border you'll die" which applies to our lady "star". Well, I also remember that they have some kind of a tubular case, and when one opens it, lightning files out.  I watched the film somewhere around 2010, it's in English and when I try to remember it, I get the vibe of a mediocre Hollywood fantasy romance. Why did Littlefinger give Sansa to the Boltons? This question is about the TV show only.  In the books, Sansa is still with Littlefinger and everything that happens between Sansa and Ramsay in the show actually takes place between Ramsay and Jeyne Poole in the books.  However I don't recall why Littlefinger sends Sansa north. Apparently, in the books, it's safer to keep her traveling. So why did he do it in the show? When I click the bounty info icon on the iOS app. The added bounty description and reason is not shown.  For example: I am trying to get from a particular point more informations about the surroundings (which are also points). So I wrote this:  SELECT *    FROM osm_point    WHERE ST_DWithin(way,(ST_SetSRID(ST_MakePoint(12.2385578688105, 51.8435615931295), 4326, 1000);   But there is an error     ERROR: FEHLER:  LINE 3: ...T_MakePoint(12.2385578688105,   51.8435615931295), 4326, 1000) ^ SQL state: 42601 Character: 133   What is wrong? How to show that $\log (\frac{2a}{1-a^2}+\frac{2b}{1-b^2}+\frac{2c}{1-c^2})= \log\frac{2a}{1-a^2}+ \log \frac{2b}{1-b^2}+ \log \frac{2c}{1-c^2}$ If $\log (a +b +c) =\log a+\log b+\log c$ then show that $$\log \left(\frac{2a}{1-a^2}+\frac{2b}{1-b^2}+\frac{2c}{1-c^2}\right)= \log\frac{2a}{1-a^2}+ \log \frac{2b}{1-b^2}+ \log \frac{2c}{1-c^2}$$  Trial: If put $a=\frac{2a}{1-a^2}$ and the similar we are done. Can we do this in this way? Otherwise how to do. Please help. What is the differance between Linked and Appended data from external .blend files? Coloring a black and white PDF graphic I have a graphic in PDF format (originally converted from an SVG) that is monochromatic (black on white). Is it possible using TikZ or PSTricks but not (Illustrator or Inkscape) to include this image in a different color?  Example:    While it lasts (there seems to be no long term way to host a pdf), you can .  Edit: Simple was perhaps a bit of a misnomer - the pdfs are cropped and monochromatic, but to intricate to redraw on my own. The above example is a character from a font (which I can recolor), but it gives a good example of what shapes I am talking about. Is their a way to move multiple vertices gradually at a time? I have moved multiple vertices gradually but a set of vertices at a time not all at a time, as shown in the animation below (First I moved the four vertices from top, then three, then two and at last the last vertex).  I wanted to do the same thing as shown in the animation below but all at a time. Closing changes: [on hold], unclear, too broad, opinion-based, off-topic reasons, bye-bye to Too Localized Ctrl+Alt+← can usually be set to restart X, however I can't find the option to allow this (it is disabled by default).  I have looked in System-&gt;Preferences-&gt;Keyboard and System-&gt;Preferences-&gt;Keyboard Shortcuts but I can't find an option to enable it.  Where can I change this setting? Could gravity accelerate light? Gravity causes anything with energy to accelerate toward the source. Black holes, for example, have such strong gravity that they pull in light and don't let any escape. But can acceleration still apply to light? The speed of light is constant, of course, but why are photons affected by gravity yet aren't accelerated by it?  Edit: My main question is why photons aren't affected in the same way as most other particles. I'm perfectly aware that it cannot surpass lightspeed, but I want to know what makes it unaffected by acceleration while other particles are affected. How do I list all of the files in a commit? I am looking for a simple Git command that provides a nicely formatted list of all files that were part of the commit given by a hash (SHA-1), with no extraneous information. I have tried: git show a303aa90779efdd2f6b9d90693e2cbbbe4613c1d  Although it lists the files, it also includes unwanted diff information for each. Is there another git command that will provide just the list I want, so that I can avoid parsing it from the git show output? Let $n\geq 2$ and let $k$ be "considerably larger" than $n$ (like some large multiple of $n$). Then for each $i$ such that $0&lt;i&lt;n$ and $\gcd(i,n)=1$ let's define $$c_i=\left|\{p_j\;|\; p_j\equiv i \mod n,\;\mbox{where $p_j$ is the $j$-th prime, $1\leq j\leq k$}\}\right|$$ so $c_i$ represents how many of the first $k$ primes are congruent to $i$ modulo $n$.  What can we say about $c_i$s, that is about the distribution of the first $k$ primes modulo $n$?  I thought the distribution will be seemingly random, and that is mostly true - for example $c_i$s are always very close together. But there are observable non-random patterns. For example for $n=3$, for various $k$s I've tried  (up to $10^6$) I always got $c_2&gt;c_1$. If this were just some kind of random discrepancy due to distribution of small primes, it would eventually vanish for large $k$s, which I don't observe.