I have some records in MYSQL database with domain name, Now i changed domain and i want use query for find these word example.com in record column and then change to example.net.  I think if column only include domain, it's very easy but my records include domain name and some text. Like this:     it's a sample text www.sample.com and i want change it   I have some recorde like above and i want find every recorde that have sample.com text and then change it to sample.net
What MySQL query will do a text search and replace in one particular field in a table?  I.e. search for foo and replace with bar so a record with a field with the value hello foo becomes hello bar.
Create ColorRamp How can I create a ColorRamp for a Cycles material through Python?  I am able to create a new shader output node with nodes.new(type='ShaderNodeOutputMaterial'). Searching online, I see that it is only possible through C code (however, these pages dates back several years).  Is there a way to fake a ColorRamp (maybe with multiple Math nodes in greater/less than mode) or create a ColorRamp for a Cycles material through Python? Strange behaviour of "ls -a | grep ^\." I wanted to list the content of a pwd and display only file starting with dot. I tried ls -a | grep ^\. but I cannot figure out why the output contains also the files which do not start with dot. For example:  Pictures .pip .pki .profile projects Public   I know that I can achieve what I want with ls -ld .* I am just curious about this behaviour of grep which I can't explain. AngularJS leaves comments in HTML: is it possible to remove them? Unicode char {U+200B} When I try to cite more than two authors, I got this: ! Package inputenc Error: Unicode char ​ (U+200B) (inputenc)                not set up for use with LaTeX.   \documentclass[a4paper,oneside,BCOR=10mm,12pt,titlepage]{scrreprt}  \usepackage[polutonikogreek,ngerman,english]{babel} \usepackage[maxlevel=4,autostyle,german=guillemets]{csquotes} \usepackage[T1]{fontenc} \usepackage[utf8]{inputenc} \usepackage[style=mla]{biblatex} \DeclareMultiCiteCommand{\parencites}[\mkbibparens]{\parencite}{\multicitedelim‌​}  \begin{document}  \parencites[cf.][]{key1}{key2}{key3}  \end{document} Prove that $\sum_{n=1}^{\infty}\exp\left(-n^{\varepsilon}\right)$ converges. Check differentiability of multivariable functions I am trying to determine if the following functions are (totally)   differentiable at $(x,y)=(0,0)$.      $$f(x,y)=\sqrt{\vert xy \vert}$$      $$g(x,y)=e^{{{\vert x \vert}^3}y}$$   However I am not particularly sure where to start. The concept of the total derivative being the Jacobian matrix makes sense but I don't really understand how to work with functions that may not have a Jacobian matrix. Any help would be greatly appreciated! How to create a sub array from another array in Java? On every loading of a lib, I get the error:     no version information available   This lib has been compiled on another PC (ubuntu 10.04) than the one running it (mandriva 2010.2).  $ ldd /usr/local/gnu-eabi-4.5.2/i686-pc-linux-gnu/arm-eabi/lib/libbfd-2.21.so /usr/local/gnu-eabi-4.5.2/i686-pc-linux-gnu/arm-eabi/lib/libbfd-2.21.so: /lib/libz.so.1: no version information available (required by /usr/local/gnu-eabi-4.5.2/i686-pc-linux-gnu/arm-eabi/lib/libbfd-2.21.so)  linux-gate.so.1 =&gt;  (0xffffe000)  libz.so.1 =&gt; /lib/libz.so.1 (0xb77a7000)  libc.so.6 =&gt; /lib/i686/libc.so.6 (0xb7655000)  /lib/ld-linux.so.2 (0xb787a000)   Edit: the workaround didn't work. Here, we suppose that $x,y\in\mathbb{R}$ and that $x^n=y^n$, where $n$ is odd. I want to prove that $x=y$.  Maybe we can use that $x^n-y^n=(x-y)(x^{n-1}+x^{n-2}y+...+xy^{n-2}+y^{n-1})$  So, it suffices to show that if $x^n=y^n$ then $x^{n-1}+x^{n-2}y+...+xy^{n-2}+y^{n-1}\neq 0$  Any hint? Incoming light reacts with the several types of cone cells in the eye. In humans, there are three types of cones sensitive to three different spectra, resulting in trichromatic color vision. Each individual cone contains pigments composed of opsin apoprotein, which is covalently linked to either 11-cis-hydroretinal or more rarely 11-cis-dehydroretina.  The opsins (photopigments) present in the L and M cones are encoded on the X chromosome.  A very small percentage of women may have an extra type of color receptor because they have different alleles for the gene for the L opsin on each X chromosome. X chromosome inactivation means that only one opsin is expressed in each cone cell, and some women may therefore show a degree of tetrachromatic color vision. Tetrachromacy is also demonstrated among several species of birds, fish, amphibians, reptiles and insects.  Humans cannot see ultraviolet light directly because the lens of the eye blocks most light in the wavelength range of 300–400 nm.  So, besides above mentioned exceptions, is it possible due to mutations or genetic engineering to see UV or infrared. What kind of mutations should be made or are the changes to be made in the opsines to big to create 'alien' eyes? Which Stack Exchange website for machine learning and computational algorithms? I'm currently working on many machine learning and computational algorithms, such as Singular Value Decomposition, Support Vector Machines, and others.  I'd like to ask questions about these topics, but I don't know which Stack Exchange website to use to post my questions.   Should I use ? Should I use ? Should I use ? Should I use ?   How do I tell?  What criteria do I use? When to use "do" in phrases which are not questions? I have two questions. First, which command lists files and directories, but lists directories first?  Second question: I want to copy a list of files into a single directory, but make the target directory the first filename in the command. The add comment link and comment box overlaps bounty box The following you could have seen in  (sorry, I've commented there, so you won't see it anymore) in Chrome 35.0.1916.153 m (current version). Notice how the add comment link overlaps the bounty box:    The same you can observe with a comment box on other sites, e.g. at this time in :    Could you shift it a bit down ?  It seems that it happens on more than just Stack Overflow (maybe all sites ?). Send urgent mail in Gmail Is it possible to set the "urgent" flag in Gmail for outgoing mail? I'd like to be able to flag time-sensitive emails as such. space on disk running low error logging /var/log/cups/error.log I have Lubuntu 16.10 installed on my disk mounted as /.  The problem is that the CUPS log file( /var/log/cups/error.log)  grows all the time until I no have free space left on the disk...   So when I delete that file, the space on disk freed up again  I already tried:    fsck disk usage analyzer every apt-cleaning/autocleaning, and dependencies fixing.    How should I proceed?  du -sxh:  9,0G    .  Model: ATA ST3160815AS (scsi) Disk /dev/sda: 160GB Sector size (logical/physical): 512B/512B Partition Table: msdos Disk Flags:   Number  Start   End     Size    Type      File system     Flags  1      32,3kB  50,3GB  50,3GB  primary   ext4            boot  2      50,3GB  160GB   110GB   extended  5      50,3GB  158GB   108GB   logical   ext4  6      158GB   160GB   2136MB  logical   linux-swap(v1)   parted --list &amp;&amp; sudo df -h:  Model: ATA ST3160815AS (scsi) Disk /dev/sda: 160GB Sector size (logical/physical): 512B/512B Partition Table: msdos Disk Flags:   Number  Start   End     Size    Type     File system  Flags  1      32,3kB  50,3GB  50,3GB  primary  ext4         boot  2      50,3GB  160GB   110GB   primary  ext4   Filesystem      Size  Used Avail Use% Mounted on udev            985M     0  985M   0% /dev tmpfs           201M  6,3M  195M   4% /run /dev/sda1        46G   43G  709M  99% / tmpfs          1003M  188K 1003M   1% /dev/shm tmpfs           5,0M  4,0K  5,0M   1% /run/lock tmpfs          1003M     0 1003M   0% /sys/fs/cgroup tmpfs           201M   36K  201M   1% /run/user/1000 /dev/sda2       101G   60M   96G   1% /media/aram/ Can I run the python interpreter without generating the compiled .pyc files? queries with db_select don't respect integers When I check "SHOW PROCESSLIST" in phpMyAdmin I can see lots of queries where argument-integers are being inserted as strings (with single quotation marks).  I'm wondering if this is due to the way phpmyadmin reports the queries (if it puts every argument between quotation marks) of if it is db_select that puts every argument between quotation marks.  An example of my code where integers are being used as arguments:  $select-&gt;join('taxonomy_index', 't_'.$key, 't_'.$key.'.nid = n.nid AND t_'.$key.'.tid = :tid_' . $key, array(':tid_'.$key =&gt; (int)$tid)); $select-&gt;condition('t_'.$key.'.tid', (int)$tid);   As you can see I explicitly write (int)$tid but in my query log I can see the following:  ... WHERE (t_0.tid = '10') ...   The big question is: How can I be sure that integers are being treated as integers in my queries? I don't want MySQL having to transform strings to integers. Are there substitutes for chain lubricant? With long journeys and particularly during winter I have noticed that the salt erodes the chain very quickly, even when I have lubricated the chain beforehand. When you are missing proper chain lubricants, what would you use as a substitute? Could you use cooking oil if you are missing the right stuff, or should I keep a small bottle of oil with me on my rides?  Related Set the maximum character length of a UITextField