I have entries with different formats: customer_cpf 12.34.56 1234.56 12-34-56  So I'm receiving only numbers in a form and need to get it's row by comparing avoiding characters excepting numbers. I'm trying this: SELECT * FROM `customers` WHERE customer_cpf REGEXP '^[0-9]$' = &quot;123456&quot;;  But it returns nothing. How can I perform this WHERE clause?
I'm looking to find records in a table that match a specific number that the user enters.  So, the user may enter 12345, but this could be 123zz4-5 in the database. I imagine something like this would work, if PHP functions worked in MySQL. SELECT * FROM foo WHERE preg_replace(&quot;/[^0-9]/&quot;,&quot;&quot;,bar) = '12345'  What's the equivalent function or way to do this with just MySQL? Speed is not important.
Setting or modifying a (system wide) environment variable in cmd.exe I am looking for a convenient way to add and/or modify and/or delete an environment variable from the command line. Particularly, I find myself at times in situations when I have to add a few variables in cmd.exe.  I'd be grateful if someone showed me a non-GUI way to modify (that is: to add a new directory to) the %PATH% variable.  The change should be be permanent, not just for duration of the cmd session. How can I play encrypted DVD movies? Fatou's lemma and measurable sets I don't know how can I imply Fatou's lemma for any measurable sets $A_k$, that is, $$\lambda(\liminf A_k)\le\liminf\lambda(A_k).$$ How can I prove it? And is there any example in $\mathbb R$ of sequence of measurable sets $A_k$ such that $A_k\subset[0,1]$, $\lim\lambda(A_k)=1$, but $\liminf A_k=\varnothing$ ? Thanks for your help! Is history expansion disabled in scripts? I understand the following error is due to ! used for history expansion:  $ echo "Hello!Tim" bash: !Tim: event not found   However if I put the command into a script and run the script, there is no problem:  $ cat myscript echo "Hello!Tim" $ bash myscript  Hello!Tim   Why is that? Does the bash manual mention the reason? biblatex: Cite commands with the same author prints authors name twice I'm using biblatex 1.4b, and Biber 0.9. However, I think the problem is with my settings, not with the versions of those programs.  I'm trying to cite a single author, and produce their name, followed by the dates of two papers, using the authoryear-ibid style, and natbib compatability. Here's my biblatex preamble:  \usepackage[style=authoryear-ibid,natbib=true,backend=biber]{biblatex}   What I want is for the following command: The works by \citet{Blau81, Blau88} ... to produce: The works by Blau (1981; 1988) ... however, what I'm getting is: The works by Blau (1981); Blau (1988)...  I know that biblatex knows they're the same author, since in the bibliography they fall under the same name (i.e. after the first instance of the name, there's just a dash instead of the name)  What am I doing wrong here? I've also tried it with the commands \cite and \cites, and neither produces what I want.   (crossposted with comp.text.tex) If $A|B$ and $B|A$ then prove $A=\pm B$ If $A|B$ and $B|A$ then prove $A=\pm B$   So far I have $A|B \iff AX=B$ and $B|A \iff BY=A$ with $X,Y \in \mathbb{Z}$  Not sure how to finish, any help. Arrows linking table cells I'm currently trying to add arrows in my synthetic division example to show people clearly how synthetic division works. I'm working on Overleaf.   The code for my synthetic division right now is:  \begin{tabular}{c |r r r r r}     &amp;1&amp; 4 &amp; -1&amp;16&amp;-20\\   1&amp;&amp; 1 &amp; 5 &amp; 4&amp;20\\   \hline    &amp;1 &amp;5 &amp; 4 &amp; 20 &amp;\rule{3pt}{16pt}\;0\\   \end{tabular}   How would I add arrows to this? For instance, a down arrow going from the first 1 to 1, then an upwards arrow pointing right from 1 to 1, then an arrow pointing down from 1 to 5, etc. Basically I would like to add arrows that look like this: Optional argument after splat argument Show that  the  alternating  group  $A_4$  of all even permutations of $S_4$ does not contain a  subgroup of order $6$.   For me am thinking to write all elements of $A_4$ and trying to find every cyclic subgroup generated by each element of $A_4$, then I have to check whether there exist such a subgroup or not! This is a long procedure for me, I ask if there is a short way to do this. event.preventDefault() vs. return false How much time until an unused hard drive loses its data? Do you guys know how much time needs to pass until the data stored on a hard drive starts to degrade?   To keep the data intact for long periods of time, I heard you need to periodically rewrite it on the hard drive, like every 5 years or so. Is it true? UIActionSheet is not showing separator on the last item on iOS 7 GM Problem with TP-Link TL-WN823N Recently I installed Ubuntu 16.04 but cant get the usb wifi adapter to work properly , can anyone help me?  When wifi adpater is plugged , the lsusb output:  Bus 001 Device 003: ID 2357:0109 Bus 001 Device 002: ID 0e0f:000b VMware, Inc.  Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub  Bus 002 Device 004: ID 0e0f:0008 VMware, Inc.  Bus 002 Device 003: ID 0e0f:0002 VMware, Inc. Virtual USB Hub Bus 002 Device 002: ID 0e0f:0003 VMware, Inc. Virtual Mouse Bus 002 Device 001: ID 1d6b:0001 Linux Foundation 1.1 root hub   When wifi adapter is unplugged , the lsusb output:  Bus 001 Device 002: ID 0e0f:000b VMware, Inc.  Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub Bus 002 Device 004: ID 0e0f:0008 VMware, Inc.  Bus 002 Device 003: ID 0e0f:0002 VMware, Inc. Virtual USB Hub Bus 002 Device 002: ID 0e0f:0003 VMware, Inc. Virtual Mouse Bus 002 Device 001: ID 1d6b:0001 Linux Foundation 1.1 root hub Management of fruit bowls on the Enterprise D I have noticed that guest quarters on the Enterprise D have fruit bowls on their tables.  A prominent instance is the fruit bowl in Berlinghoff Rasmussen's quarters in "".  The first thing that Rasmussen does when Data takes him to his guest quarters is take a piece of fruit and shove it in his pocket.  Who replicates fruit for these fruit bowls before guests arrive?  More generally, who removes unused fruit and tidies quarters after guests leave?  Is there a ship hospitality staff, perhaps including Guinan's wait staff in Ten Forward? MPPT charging a li-ion battery I just designed this MPPT solar charge controller which outputs 4.2 V regulated via MPPT, it uses the SPV1040 IC. This will be used on a satellite with 4 side panels, each with 8 solar cells in parallel outputting 2.6 V at approximately 122 Ma. Each panel will have this exact circuit and all the outputs will be connected in parallel to a 3.7 V lithium ion camera battery.  When active only 1 solar panel will be active and the other MPPT circuits will be offline or providing a very low amount of current. How should I connect the 4.2v to the battery, just directly or using some sort of controller to stop charging at 4.2v? Keep in mind the battery will always have a load and it will charge for around 50m in a 90m cycle due to being eclipsed. I would obviously like the battery to last as long as possible so I am not sure what are the implications of constantly having a battery connected to 4.2 V during 50m. Thanks.   The schematic was made based off a simulation made using the ST Edesignsuite directly from the provider.  Excuse my previous question about this, wasn't properly worded. Prove by contradiction (not using a calculator) that $\sqrt6 + \sqrt2 < \sqrt{15}$? My Indian passport book cover is detached from the main book, but all other information, as well as the book is fine. I am traveling to India in 2 days. What should I do? Will there any problem at the airport? Output from ls has newlines but displays on a single line. Why? what is the total number of distinct arrangements of $n$ oranges and $n$ apples around a round table? I have no idea how to go about. Does the proof of Bolzano-Weierstrass theorem require axiom of choice?