My query is:   SELECT * FROM enwiki.page where title_text = 'drug';   One of the results I got has the tilte_text = 'Drûg'. How can I prevent that?
I have a MySQL table with utf8 general ci collation. In the table, I can see two entries:  abad abád  I am using a query that looks like this:  SELECT *  FROM `words` WHERE `word` = 'abád'   The query result gives both words:  abad abád  Is there a way to indicate that I only want MySQL to find the accented word? I want the query to only return    abád    I have also tried this query:  SELECT *  FROM `words` WHERE BINARY `word` = 'abád'   It gives me no results. Thank you for the help.
What's the fastest way to make money online? Everything in the online world is expensive, well the best things are. We all want the luxurious apartment with 10 cars garage and the best weapons but to achieve that, we need money. Which missions or activities give the most cash ? Viruses at this period of time do not fit the current definition of life.   Much of the reasoning behind this is that we currently believe that all life must be made up of cells.  Also, many biologist/scientists say that viruses are not living because all they are is just chemicals carrying out their predefined chemistry.   Has anyone every considered the fact that cells, the supposed building blocks of life, themselves simply only carry out predefined chemical actions? All actions cells carry out are chemically driven, not consciously or spiritually driven. Cells do not make choices, they follow chemical directions present in their DNA and RNA. Viruses act very similarly, following the action transcribed in their DNA or RNA.   How can we really even draw a defined line of what life is? Let X be a T1 space, and show that X is normal if and only if each neighbourhood of a closed set F contains the closure of some neighbourhood of F Let $X$ be a $T_1$-space, and show that $X$ is normal if and only if each neighbourhood of a closed set $F$ contains the closure of some neighbourhood of $F$.  I saw this statement in the book Introduction to topology and modern analysis by Simmons. I tried to prove it but I did not get any where. How may it be proved? Should first and last name be formatted? EntityFieldQuery display pager How do I display pager using EntityFieldQuery for fetch results? I can't find complete example.  I am doing simmilar to:   But I miss part to output simple pagination links (1,2,3... for every next page). How to display Toast in Android? How can a point-particle have properties? I have trouble imagining how two point-particles can have different properties.  And how can finite mass, and finite information (ie spin, electric charge etc.) be stored in 0 volume?  Not only that, but it can also detect all fields without having any structure. Maybe it can check curvature of spacetime to account for gravity, but how can a point contain the information of what the other fields-vectors are? This seems to mean that also the information/volume in space is infinite.  Mathematically, a point cant have any intrinsic structure, so how does physics which is a mathematical theory explain this? Standard formula for quick calculation of scores I have three datasets as follows:   Dataset A can have a maximum score of 30. (Individual scores can be from 1 to 30) Dataset B can have a maximum score of 45. (Individual scores can be from 1 to 45) Dataset C can have a maximum score of 25. (Individual scores can be from 1 to 25)   The three datasets contribute equally to a final score, hence it is 33.33% each. i.e. (33.33% for dataset A + 33.33% for dataset B + 33.33% for dataset C) = 100% (final score)  I have the following scores in each dataset:   Dataset A: 22 Dataset B: 15 Dataset C: 10   Is there a quick formula that I can use to work out the final score, based on the above datapoints?   (This is not a homework question.) What will happen when Winter Bash is over? Tomorrow (January 2nd 2019) is the day that Winter Bash will be gone.  So I am thinking: Will there be some sort of a final ranking page anywhere?  It would be nice so I don't need to keep going to  every day to see my rank.  If there isn't going to be anything like that, what should I do to see my final rank on Winter Bash? Are there any other methods to apply to solving simultaneous equations? We are asked to solve for $x$ and $y$ in the following pair of simultaneous equations:  $$\begin{align}3x+2y&amp;=36 \tag1\\ 5x+4y&amp;=64\tag2\end{align}$$  I can multiply $(1)$ by $2$, yielding $6x + 4y = 72$, and subtracting $(2)$ from this new equation eliminates $4y$ to solve strictly for $x$; i.e. $6x - 5x = 72 - 64 \Rightarrow x = 8$. Substituting $x=8$ into $(2)$ reveals that $y=6$. I could also subtract $(1)$ from $(2)$ and divide by $2$, yielding $x+y=14$. Let $$\begin{align}3x+3y - y &amp;= 36 \tag{1a}\\ 5x + 5y - y &amp;= 64\tag{1b}\end{align}$$ then expand brackets, and it follows that $42 - y = 36$ and $70 - y = 64$, thus revealing $y=6$ and so $x = 14 - 6 = 8$. I can even use matrices! $(1)$ and $(2)$ could be written in matrix form: $$\begin{align}\begin{bmatrix} 3 &amp;2 \\ 5 &amp;4\end{bmatrix}\begin{bmatrix} x \\ y\end{bmatrix}&amp;=\begin{bmatrix}36 \\ 64\end{bmatrix}\tag3 \\ \begin{bmatrix} x \\ y\end{bmatrix} &amp;= {\begin{bmatrix} 3 &amp;2 \\ 5 &amp;4\end{bmatrix}}^{-1}\begin{bmatrix}36 \\ 64\end{bmatrix} \\ &amp;= \frac{1}{2}\begin{bmatrix}4 &amp;-2 \\ -5 &amp;3\end{bmatrix}\begin{bmatrix}36 \\ 64\end{bmatrix} \\ &amp;=\frac12\begin{bmatrix} 16 \\ 12\end{bmatrix} \\ &amp;= \begin{bmatrix} 8 \\ 6\end{bmatrix} \\ \\ \therefore x&amp;=8 \\ \therefore y&amp;= 6\end{align}$$  Question Are there any other methods to solve for both $x$ and $y$? Is there a program that can make live USBs for any distro, iso, you get the point. I can only find ones that make live USBs for other linux distributions and none for anything else. What is the easiest way to encode a PHP string for output to a JavaScript variable?  I have a PHP string which includes quotes and newlines.  I need the contents of this string to be put into a JavaScript variable.  Normally, I would just construct my JavaScript in a PHP file, à la:  &lt;script&gt;   var myvar = "&lt;?php echo $myVarValue;?&gt;"; &lt;/script&gt;   However, this doesn't work when $myVarValue contains quotes or newlines. Tikz and ctable incompatibility, gives error when printing When I print a report I get an error:     An error exists on this page. Acrobat may not display the page   correctly. Please contact the person who created the PDF document to correct the problem   After a lot of debugging, I've found that this MWE reproduces the problem. I've tried it on three different computers with the same error.   \documentclass{standalone}           \usepackage{tikz} \usepackage{ctable} \begin{document} \begin{tikzpicture} \filldraw[opacity=.5] (0,0) rectangle (1,1); \end{tikzpicture} \end{document}   When loading the ctable package, the image is changed (the opacity disappears), so it seems the error comes from some incompatibility between ctable and opacity in tikz. The error only appears when trying to print though, acrobat before attempting to print. (Printing either to a pdf file or to a real printer)  I have the following versions of tikz and ctable:      tikz.sty    2013/12/13 v3.0.0   ctable.sty    2014/04/25 v1.29   How can I fix this?    EDIT: I found the warning Transparency disabled: incompatible with tikz package from ctable so I guess this incompatibility can explain the error in the first MWE.  However, I continued digging and found that the spy library seem to be incompatible with ctable as well.   Here's an MWE that generates the same error when printing (either to a pdf file or to a real printer):   \documentclass{standalone}           \usepackage{tikz} \usetikzlibrary{spy} \usepackage{ctable} \begin{document} \begin{tikzpicture}[spy using outlines={size=2cm,connect spies}] \begin{scope} \spy on (-3,.25) in node at (2,0); \end{scope} \end{tikzpicture} \end{document}   There seem to be a serious problem with using tikz + ctable, can it be fixed? How to Connect & Share your Internet Connection (Wired & Wireless) I have Ubuntu 12.04 on a HP 430 notebook and this has a single wired internet connection and I would like to share this with a LG Optimus One with Android 2.3.3. I followed  instructions and created a hotspot as shown below, but UbuntuHost is not visible on the LG Optimus One when I enable the Wifi on it.  To summarize, I want my Laptop with an internet connection to act as a WiFi router and access the internet from other devices (LG Optimus One with Android in this case).  What additional steps have to be done? What's the difference between \usepackage{ngerman} and \usepackage[ngerman]{babel} How can I use Photoshop to imitate a photo taken with a low-quality camera? How can I create an image in Photoshop that imitates a photo taken with a low-quality phone camera? Examples of qualities I want to simulate:   blurring in some areas caused by a dirty lens low quality exposure handling in the darkroom noise   Some examples: Viruses in wine? The Story  I installed wine some time ago, and after trying out some versions of Cinema 4D that were "free", I looked in the comments of the videos, and saw some people complaining about viruses. I got worried, downloaded and installed MalwareBytes, and scanned my "system". Of course, since MalwareBytes was runnning through Wine, it only scanned ~/.wine/C:. It found many viruses/trojans and I opted to delete them. I did so.  Questions:   Assuming there is any malware left, can this malware spread into my OS? Tell me the entire truth on what can happen. I deleted my entire .wine directory and am planning to uninstall wine later. I am the only user out of the three on this system that runs wine programs, but wine is installed for all. Is that enough, or must I do more? Please be specific on what I should do because I want to be 100% sure that there are no viruses.   I am sure that many others have these questions too, so please answer this question to the point.   Additional information:  Wine was installed with sudo-apt get. The exact commands can be found here:   Commands:  sudo add-apt-repository ppa:ubuntu-wine/ppa -y sudo apt-get update sudo apt-get install wine1.6 -y   I did try to install a font that was a ttf font. I tried to convert it to otf with no success. Then, I placed it in the fonts directory directly. I then saw that some people said it was malicious, and I removed it.  This question was flagged as  a duplicate of this question:  It is not the same. This question is more precise, as it specifies two scenarios involving viruses, not risks of viruses. The other question talked about Internet Explorer; this one does not mention the installation of any programs.  Note: wine was installed with sudo privileges, so does that mean it runs with sudo privileges? For which $n$ does $\frac{1}{a}+\frac{1}{b}+\frac{1}{c}=\frac{1}{a+b+c}$ imply $\frac{1}{a^n}+\frac{1}{b^n}+\frac{1}{c^n}=\frac{1}{a^n+b^n+c^n}$ I'm having trouble finishing a problem on an old national competition.  As the title states, the question says asks:  Given $a,b,c \neq 0,a+b=c$ such that $\frac{1}{a}+\frac{1}{b}+\frac{1}{c}=\frac{1}{a+b+c}$,  Find all integers $n$ such that $\frac{1}{a^n}+\frac{1}{b^n}+\frac{1}{c^n}=\frac{1}{a^n+b^n+c^n}$.  I know that if it is true for $n$, it is also true for $-n$ since $(a^n+b^n+c^n)(\frac{1}{a^n+b^n+c^n})=1$ and $(a^n+b^n+c^n)(\frac{1}{a^n}+\frac{1}{b^n}+\frac{1}{c^n})=1$ and the statment follows for $-n$ given that we can make the substitution for $n$. Thus I found out that $n=-1$ satisfies the equality.  I also know that it fails for all even $n$. If $n$ were even, $(a^n,b^n,c^n)$ would all be positive, and Titu's Lemma asserts that $\frac{1}{a^n}+\frac{1}{b^n}+\frac{1}{c^n}\geq \frac{9}{a^n+b^n+c^n}$. Thus $n$ must be odd.  I also observed that $(2,-1,1)$ was a solution, and from here noted that this particular solution satisfies all odd $n$.  I have been trying to prove that all other solutions satisfy all odd $n$ with no success.  Any help would be greatly appreciated. Thanks! Position of the adverb "substantially" How to properly render smoke on a transparent background? When rendering volumes with Film > Transparent enabled, the alpha appears to be the wrong type (premultiplied/straight). In the 3D view it works as expected:    This is a known .  Is there any way to work around this?