I want the query like below:   select * from tbl where LOWER(name) = $name  My current query is:  $resultArr = db_select('adbanner', 'n')     -&gt;fields('n')     -&gt;condition(LOWER('n.blog_title'), $page, '=')     -&gt;execute()     -&gt;fetchAll();    But it doesn't work.  How should I write this type of query?
I am trying to write a condition into a SQL WHERE clause that forces the column comparison to a variable to be compared in lowercase. However the addExpression function isn't accomplishing this (since that is putting the expression in the field selection, not the where clause.  Here is what I have tried:  $category = 'mobile wifi'; $query = db_select('taxonomy_term_data', 'ttd')     -&gt;fields('ttd', array('tid')); $query-&gt;innerJoin('taxonomy_vocabulary', 'tv', 'ttd.vid = tv.vid'); $query-&gt;addExpression("LOWER(ttd.name) = $category"); $result = $query-&gt;condition('machine_name', 'images_cat', '=')     -&gt;execute()     -&gt;fetchAssoc();   And this:  $category = 'mobile wifi'; $query = db_select('taxonomy_term_data', 'ttd')     -&gt;fields('ttd', array('tid')); $query-&gt;innerJoin('taxonomy_vocabulary', 'tv', 'ttd.vid = tv.vid'); $result = $query-&gt;condition('machine_name', 'images_cat', '=')     -&gt;condition('LOWER(ttd.name)', $category, '=')     -&gt;execute()     -&gt;fetchAssoc();   The second one becomes invalid and the first one causes the problem I mentioned above. Any thoughts or suggestions?  Thanks, Patrick
How do I install Firefox 52 ESR on 16.04? This  asks how to install FF32 bit while keeping the 64 bit.  I want the much more simple thing: is there a canonical way to install firefox 52 ESR as "default" firefox in my 16.04?  I found this  ... but there are no packages; probably no wonder given the fact that the linked blog article dates back to 2012.  So, 2017, Ubuntu 16.04; how to install FF 52 ESR (as I simply need the java plugin to work for me).  ( my current solution: I downloaded the TAR file from mozilla, extracted that to /opt; and then changed /usr/bin/firefox to be a link to that ESR version of firefox. works, but ugly ) Programmatically get own phone number in iOS Is there any way to get own phone number by standard APIs from iPhone SDK? Windows 10 doesn't shut down properly No notification was received for an edit to a post My son is going on 5 and starting to learn a lot about how we're created. I've been with my husband for 10 years, but nearly 6 years ago I had no other choice but to move 1000 miles away and after trying the long distance thing it didn't work so we split up.   I ended up going through a rough patch and started dating an abusive jerk. After a year I was pregnant. He threatened me trying to force me to have an abortion and I refused. His grandmother was chief of police and he scared me into moving back to Florida.  Eventually, when I was 4 months along in my pregnancy my husband and I picked up right where we left off. He loved me so much and accepted our son as if he was his own and has done an amazing job at raising him.   He enrolled in college while I was pregnant, got us a house and went above and beyond to care for us both (as after giving birth I became very ill due to rare brain and spine conditions). I've always tried to do right by my son. Since day one, even while with my husband, I tried to keep the sperm donor involved. But he wanted no part of his son.  My husband stepped up when the biological father refused. The biological father would pretend that he cared, only to tell me he never cared about him anyway and was just trying to manipulate me into stopping child support (which I did anyway after the first year: I felt it wasn't right to take his money when my son had a dad who loved, supported and wanted him from the beginning).  This is a very long story so I'll try and make it not so much of a novel. The sperm donor has made it very clear he wants nothing ever to do with my son. My husband has been Dad since the moment my son entered this world. I've always planned to tell my son as early as possible. I think now, or in a few years, it won't be as hard on him compared to us telling him when he's a teen and who knows how he'd handle it.   I just don't know what to do. We have an extremely happy loving family. My son adores his dad. We never argue, we have a very happy non-dysfunctional marriage. I just feel we have a very special family. But I refuse to lie to my son. What if we wait and someone else maliciously tells him? Or if, when he's older and finds out, he spirals out of control?  I'm so confused, I just want to do the right thing and desperately need advice. Especially from others who have been through similar circumstances. We're planning on meeting with therapists and I guess child development specialists, if someone could also point me in the right direction for what type of doctor is best suited in this situation.   Also my son is very happy. He has a wonderful life and I feel as if he would do fine, knowing how much he loves his dad and just beginning to really grasp the concept of life. I don't think it would change anything for him, if that makes sense. I've been worrying over this for 5 years and really need some answers! Is there any possibility of setting up two factor authentication (2FA) for Stack Exchange OpenID authentication?  I could just use my (already 2FA-enabled) Google account for Stack Exchange, but I would prefer to continue use Stack Exchange OpenID.  After  (which, I appreciate, didn't affect Stack Exchange, as you use IIS and Schannel, not OpenSSL), there have been a lot of recommendations to change passwords and to enable 2FA where possible.  So, what are the chances of a text-messaging-based or Google-Authenticator-based 2FA for Stack Exchange? What is the best way to globally change the amount of vertical space between items in list environments? Factorial sum estimate $\sum_{n=m+1}^\infty \frac{1}{n!} \le \frac{1}{m\cdot m!}$ Prove that:  $$\displaystyle \sum_{n=m+1}^\infty \dfrac{1}{n!} \le \dfrac{1}{m\cdot m!}$$  I have tried induction on $m$ but it does not work very well. Any suggestion? How do I move my website to a new server without interruption to email? Diplomacy Attacking a Territory as they move Python ( or general programming ). Why use  instead of != and are there risks? Why is Android File Transfer necessary? Apparently newer versions of Android require the use of Android File Transfer. I have an older machine that doesn't require this, and just mounts as a USB mass storage device. I can't see a technical reason why Android File Transfer is now required when it used not to be.  What changed in order to make this necessary? Why is it necessary? Is there a safe way to determine how powerful an opponent is? Can Jupiter be ignited? Our solar system itself contains two candidate "Earths"  One is Jupiter's moon Europa and another is Saturn's moon Titan. Both of them have the problem of having at low temperature as Sun's heat cannot reach them.    Jupiter is made up mostly of Hydrogen so is our Sun. Can we ignite Jupiter so that it will produce enough heat to warm these two earth like planets/satellites? What can be consequences of any of such attempt? I would like to use client-side Javascript to perform a DNS lookup (hostname to IP address) as seen from the client's computer. Is that possible? Recently I have installed an older version of Ubuntu on my old machine. Whenever I try to install any software, I get an error saying it couldn't be found:  $ sudo apt-get install vlc Reading package lists... Done                Building dependency tree        Reading state information... Done     E: Couldn't find package vlc I get these weird characters when I try to print out a vector element! Unable to activate Windows 8 Computing the integral of $\log(\sin x)$ How to compute the following integral?  $$\int\log(\sin x)\,dx$$    Motivation: Since $\log(\sin x)'=\cot x$, the antiderivative $\int\log(\sin x)\,dx$ has the nice property $F''(x)=\cot x$. Can we find $F$ explicitly? Failing that, can we find the definite integral over one of intervals where $\log (\sin x)$ is defined? Story about a trip to a Valley of Sound