Judging by the [documentation for date/time functions][1], you should be able to do something like:

    SELECT * FROM FOO
    WHERE MY_DATE_FIELD &gt;= NOW() - INTERVAL 1 DAY


  [1]: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-add

Be aware that the result may be slightly different than you expect. 

`NOW()` returns a `DATETIME`. 

And `INTERVAL` works as named, e.g. `INTERVAL 1 DAY = 24 hours`. 

So if your script is cron&#39;d to run at `03:00`, it will miss the `first three hours of records from the &#39;oldest&#39; day`.

 To get the whole day use `CURDATE() - INTERVAL 1 DAY`. This will get back to the beginning of the previous day regardless of when the script is run.

You&#39;re almost there: it&#39;s `NOW() - INTERVAL 1 DAY`

Didn&#39;t see any answers correctly using `DATE_ADD` or `DATE_SUB`:

**Subtract 1 day from `NOW()`**

    ...WHERE DATE_FIELD &gt;= DATE_SUB(NOW(), INTERVAL 1 DAY)

**Add 1 day from `NOW()`**

    ...WHERE DATE_FIELD &gt;= DATE_ADD(NOW(), INTERVAL 1 DAY)

Sure you can:

    SELECT * FROM table
    WHERE DateStamp &gt; DATE_ADD(NOW(), INTERVAL -1 DAY)

when search field is timestamp and you want find records from 0 hours yesterday and 0 hour today use construction

    MY_DATE_TIME_FIELD between makedate(year(now()), date_format(now(),&#39;%j&#39;)-1) and makedate(year(now()), date_format(now(),&#39;%j&#39;))  

instead 

     now() - interval 1 day



I don&#39;t quite understand the syntax behind the `sorted()` argument:

    key=lambda variable: variable[0]

Isn&#39;t `lambda` arbitrary? Why is `variable` stated twice in what looks like a `dict`?


Syntax behind sorted(key=lambda: ...)

First off I&#39;m using Mac.

Next, I need to execute this &quot;file.sh&quot; we will call it. Everytime I need to execute it I have to open Terminal and type:

    cd /Users/Jacob/Documents/folderWithFileInIt
    bash file.sh

This is okay, but I feel like it would be a lot quicker if I make the file execute on double click, don&#39;t you think?

So my question is, how do I make this file executable via double click?

My ideas were either:

a) type something like chmod into terminal and change permissions?

b) make a file, put code I wrote above in it ^ and then make that file executable?

c) make an automation somehow to do this?

Which way is best, or is there an even better way? Also please explain as much as you can, I&#39;m new to Terminal. Thanks.

How do I make this file.sh executable via double click?

Is there a way in a MySQL statement to order records (through a date stamp) by &gt;= NOW() -1 so all records from the day before today to the future are selected?

Select records from NOW() -1 Day

<p>Is there a way in a MySQL statement to order records (through a date stamp) by >= NOW() -1 so all records from the day before today to the future are selected?</p>


I am using Windows 7 and XAMPP. I am trying to export my database and while in the process the table names are converted to lower case.

I have searched a lot, I know I have to change the value of `lower_case_table_names` from `0` to `2`, but where do I have to change this value, in which file?


Where to change the value of lower_case_table_names=2 in XAMPP on Windows?

I want to sort the following data items in the order they are presented below (numbers 1-12):
&lt;pre&gt;
1
2
3
4
5
6
7
8
9
10
11
12&lt;/pre&gt;


However, my query - using `order by xxxxx asc` sorts by the first digit above all else:
&lt;pre&gt;
1
10
11
12
2
3
4
5
6
7
8
9&lt;/pre&gt;

Any tricks to make it sort more properly?

Further, in the interest of full disclosure, this could be a mix of letters and numbers (although right now it is not), e.g.:
&lt;pre&gt;
A1
534G
G46A
100B
100A
100JE
&lt;/pre&gt;
etc....

Thanks!

**update: people asking for query**

    select * from table order by name asc

MySQL &#39;Order By&#39; - sorting alphanumeric correctly

I have a MySQL table which contains the following type of information:

        Date            product 
    2011-12-12           azd
    2011-12-12           yxm
    2011-12-10           sdx
    2011-12-10           ssdd  

Here is an example of a script I use to get data from this table:

    &lt;?php
    
    $con = mysql_connect(&quot;localhost&quot;,&quot;username&quot;,&quot;password&quot;);
    if (!$con)
      {
      die(&#39;Could not connect: &#39; . mysql_error());
      }
    mysql_select_db(&quot;db&quot;, $con);
    $sql=mysql_query(&quot;SELECT * FROM buy ORDER BY Date&quot;);
    while($row = mysql_fetch_array($sql))
    {
    
     echo &quot;&lt;li&gt;&lt;a href=&#39;http://www.website/&quot;. $row[&#39;Date&#39;].&quot;.html&#39;&gt;buy &quot;. date(&quot;j, M Y&quot;, strtotime($row[&quot;Date&quot;])).&quot;&lt;/a&gt;&lt;/li&gt;&quot;;
     
        }
        mysql_close($con);
    ?&gt; 

This script displays every date from the table, e.g.

    12.dec 2011
    12.dec.2011
    10.dec.2011
    10.dec.2011

I would like to only display unique dates, e.g.

    12.dec.2011
    10.dec.2011


selecting unique values from a column

	(SELECT COUNT(motorbike.`owner_id`) as count,owner.`name`,transport.`type` FROM transport,owner,motorbike WHERE transport.type=&#39;motobike&#39;
	AND owner.`owner_id`=motorbike.`owner_id`
	AND transport.`type_id`=motorbike.`motorbike_id` GROUP BY motorbike.owner_id)
	UNION ALL
	(SELECT COUNT(car.`owner_id`) as count,owner.`name`,transport.`type` FROM transport,owner,car WHERE transport.type=&#39;car&#39;
	AND owner.`owner_id`=car.`owner_id`
	AND transport.`type_id`=car.`car_id` GROUP BY car.`owner_id`)


The query above returns a result like this below,

    count          name
    1              Linda
    2              Mary
    1              Steve
    1              Linda

This query is to count how many transport that owned by an owner. Linda have one car and one motorcycle,so the result should:

    count          name
    2              Linda
    2              Mary
    1              Steve

I have tried this query,but return error:


	(SELECT COUNT(motorbike.`owner_id`),owner.`name`,transport.`type` FROM transport,owner,motorbike WHERE transport.type=&#39;motobike&#39;
	AND owner.`owner_id`=motorbike.`owner_id`
	AND transport.`type_id`=motorbike.`motorbike_id`)
	UNION ALL
	(SELECT COUNT(car.`owner_id`),owner.`name`,transport.`type` FROM transport,owner,car WHERE transport.type=&#39;car&#39;
	AND owner.`owner_id`=car.`owner_id`
	AND transport.`type_id`=car.`car_id`)  GROUP BY motorbike.owner_id

Can anyone help me please?


Group by with union mysql select query

There are 2 tables, `spawnlist` and `npc`, and I need to delete data from `spawnlsit`.
`npc_templateid = n.idTemplate` is the only thing that &quot;connect&quot; the tables.
I have tried this script but it doesn&#39;t work.

I have tried this:

    DELETE s FROM spawnlist s
    INNER JOIN npc n ON s.npc_templateid = n.idTemplate
    WHERE (n.type = &quot;monster&quot;);



SQL DELETE with INNER JOIN

I have a certain element that I can select with [Selenium][1] 1.

Unfortunately I need to click the parent element to get the desired behaviour. The element I can easily locate has attribute unselectable, making it dead for clicking. How do I navigate upwards with [XPath][2]?

  [1]: http://en.wikipedia.org/wiki/Selenium_%28software%29
  [2]: http://en.wikipedia.org/wiki/XPath


Select parent element of known element in Selenium

I have a two tables.  One has manufacturer information and includes the regions where they can sell.  The other has their products for sale.  We have to limit visibility of the product based on the regions.  This is like Netflix have videos in their system that can only be viewed Everywhere (1), only in Canada (2), only in USA (3).

I am trying to make a query that tells me where the product can be viewed based on the settings in the manufacturer table.

For example, in the manufacturer table, there are two fields called expose_new and expose_used each of which will have a value of  1,2 or 3 to limit where their new or used videos can seen.

When the videos are added, they are not assigned an &#39;expose&#39; value and this is meant to be done on the fly when adding them to our index depending on the current manufacturer&#39;s expose_new or expose_used values.

**What I am trying to get is the item details and the computed value for where it can be seen based on whether it is new or used and the rule/value assigned to the manufacturer for all their new or used products.**  I need this single digit on a per-product basis to conditionally display it in a list.

The following does not work, but you will get the idea of what I am trying to do.  I have tried this with CASE statements and the following WRONG IF/ELSEIF statement.

Any help to debugger this and point me in the right direction would be appreciated.

    SELECT 
    t2.company_name,
    t2.expose_new,  // 1,2 or 3
    t2.expose_used, // 1,2 or 3
    t1.title,
    t1.seller,
    t1.status,  //can be new or used
    (SELECT 
    IF(status =&#39;New&#39;,
      (select expose_new from manufacturers where id = t1.seller),1
    )
    ELSEIF(t1.status =&#39;Used&#39;,
      (select expose_used from manufacturers where id = t1.seller),1
    )
    END IF
    ) as &#39;expose&#39;
    FROM `products` t1
    join manufacturers t2 on t2.id = t1.seller
    where t1.seller = 4238

Here is a CASE version that actually seems to execute but always results in the first value no matter what happens to be true (in this case 1).  I am not sure that I can have the addition of another test with the AND in each WHEN statement but it does not give an error, only the wrong result.

    SELECT 
    t2.company_name,
    t2.expose_new,
    t2.expose_used,
    t1.title,
    t1.status,
     CASE status
       when &#39;New&#39; and t2.expose_new = 1 then 1
       when &#39;New&#39; and t2.expose_new = 2 then 2
       when &#39;New&#39; and t2.expose_new = 3 then 3
       when &#39;Used&#39; and t2.expose_used = 1 then 1
       when &#39;Used&#39; and t2.expose_used = 2 then 2
       when &#39;Used&#39; and t2.expose_used = 3 then 3
    END as expose
    FROM `products` t1
    join manufacturers t2 on t2.id = t1.seller
    where t1.seller = 4238




MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result

I want set a dropdown(select) to be change based on the value of the entries.

I have

    &lt;select id=&quot;mySelect&quot;&gt;
      &lt;option value=&quot;ps&quot;&gt;Please Select&lt;/option&gt;
      &lt;option value=&quot;ab&quot;&gt;Fred&lt;/option&gt;
      &lt;option value=&quot;fg&quot;&gt;George&lt;/option&gt;
      &lt;option value=&quot;ac&quot;&gt;Dave&lt;/option&gt;
    &lt;/select&gt;

And I know that I want to change the dropdown so that the option with the value of &quot;fg&quot; is selected. How can I do this with JQuery?

JQuery - how to select dropdown item based on value

I&#39;m trying to change the currently selected option in a select with the Chosen plugin.

The [documentation][1] covers updating the list, and triggering an event when an option is selected, but nothing (that I can see) on externally changing the currently selected value.

I have made a [jsFiddle to demonstrate the code][2] and my attempted ways of changing the selection:

    $(&#39;button&#39;).click(function() {
        $(&#39;select&#39;).val(2);
        $(&#39;select&#39;).chosen().val(2);
        $(&#39;select&#39;).chosen().select(2);
    });

  [1]: http://harvesthq.github.com/chosen/
  [2]: http://jsfiddle.net/gakman/queZ6/

Changing selection in a select with the Chosen plugin

The field `table`.`name` contains &#39;Stylus Photo 2100&#39; and with the following query

    SELECT `name` FROM `table` WHERE `name` LIKE &#39;%Stylus 2100%&#39;

I get no results. Of course i would if i searched

    SELECT `name` FROM `table` WHERE `name` LIKE &#39;%Photo 2100%&#39;

How can I select the record by searching &#39;Stylus 2100&#39; ?

Thanks 

MySQL SELECT LIKE or REGEXP to match multiple words in one record

I need to look up rows within a particular time frame.

    select * 
    from TableA 
    where startdate &gt;= &#39;12-01-2012 21:24:00&#39; 
      and startdate &lt;= &#39;12-01-2012 21:25:33&#39;

I.e.: I need to look up rows with timestamp precision of SECONDS. How do I achieve this?

FYI: The `startdate` column is of type `TIMESTAMP`.

Oracle SQL : timestamps in where clause

I would like to know how to use NULL and an empty string at the same time in a `WHERE` clause in SQL Server. I need to find records that have either null values or an empty string. Thanks.

How to use NULL or empty string in SQL

How do I use the `created_at` field to get only the records that were created today and no other day or time?

I was thinking of a `-&gt;where(&#39;created_at&#39;, &#39;&gt;=&#39;, Carbon::now())` But Im not sure that would work.

Get only records created today in laravel

The Swift documentation at page 61 of the Swift manual hints to the possibility of using `where` to join an optional binding with a regular condition. Yet when I do it I have a warning suggesting me to substitute the `where` with a comma like in the following piece of code:

    if let geocodingError = error as? NSError where geocodingError.code == 2

Content Type	Original Author	Original Content on Stackoverflow
Question	user1092780	View Question on Stackoverflow
Solution 1 - Mysql	Jon Skeet	View Answer on Stackoverflow
Solution 2 - Mysql	William Dan Terry	View Answer on Stackoverflow
Solution 3 - Mysql	Sergey Kalinichenko	View Answer on Stackoverflow
Solution 4 - Mysql	Andrew Atkinson	View Answer on Stackoverflow
Solution 5 - Mysql	Marco Miltenburg	View Answer on Stackoverflow
Solution 6 - Mysql	Michael de Oz	View Answer on Stackoverflow

Select records from NOW() -1 Day

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Solution 5 - Mysql

Solution 6 - Mysql

How do I make this file.sh executable via double click?

Syntax behind sorted(key=lambda: ...)

Attributions