Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: MYSQL query search between dates
Top Forums Programming MYSQL query search between dates Post 302926572 by Ditto on Tuesday 25th of November 2014 08:48:43 AM
Old 11-25-2014
Quote:
Originally Posted by barrydocks
Just a little help if possible
Notice how you're using the "columns" here in quotes?
Code:
between 'today' and 'monthago')

try doing the same thing when selecting:

Code:
select id, 'today', 'monthago', today, monthago
from (
SELECT id, stdate, DATE_SUB(CURDATE(), INTERVAL 1 month) as monthago, CURDATE() as today 
FROM data_table
)

ie: lose the quotes and add nested subquery ..
(if you just lose the quotes, it'll error out "column not found" )

Also, why ask this on a Unix forum? O.o
 

6 More Discussions You Might Find Interesting

1. Programming

How to query one to many mysql

Hi there, I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks! YanYan (0 Replies)
Discussion started by: pinkgladiator
0 Replies

2. Web Development

mysql query help

hello all i have 2 columns every column in the following format column1 2011-04-01 11:39:54 column2 2019-02-03 00:00:00 i want get difference between above data as following 2 days 11:39 how to do so ? i tried many functions but nothing works please advice what is the query... (6 Replies)
Discussion started by: mogabr
6 Replies

3. Shell Programming and Scripting

mysql query in shellscript

Hi, I want to run below query on shellscript but having one problm. ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" ) here Date column contans different below dates 2011-12-01... (11 Replies)
Discussion started by: aish11
11 Replies

4. Programming

mysql query help

Hello i have created mysql query to compare to values and get difference in percentage as following: SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Discussion started by: mogabr
1 Replies

5. Shell Programming and Scripting

Search pattern on logfile and search for day/dates and skip duplicate lines if any

Hi, I've written a script to search for an Oracle ORA- error on a log file, print that line and the .trc file associated with it as well as the dateline of when I assumed the error occured. In most it is the first dateline previous to the error. Unfortunately, this is not a fool proof script.... (2 Replies)
Discussion started by: newbie_01
2 Replies

6. Programming

Need help in mysql query

Hi All, i have a table in mysql with the following data Table name Test Assettype Serial_No Status location Mouse 123456 In Stock chennai Mouse 98765 Allocated chennai Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies

LEARN ABOUT DEBIAN

trash-empty

TRASH-EMPTY(1)						      General Commands Manual						    TRASH-EMPTY(1)

NAME

       trash-empty - Empty for Command line trash utility.

SYNOPSIS

       trash-empty [arguments]

DESCRIPTION

       Remove for ever any trashed file and trashed directory.	This command is a part of trash-cli package that provides a command line interface
       trashcan utility compliant with the FreeDesktop.org Trash Specification.  It remembers the name, original path, deletion date, and  permis-
       sions of each trashed file.

ARGUMENTS

       To remove all trashed files, use 'emtpy-trash'.

       To remove files that have been in the trash more than a given number of
	      days, use 'trash-empty x', 'x' representing the number of days.

EXAMPLES

       $ date
       Tue Feb 19 20:26:52 CET 2008
       $ trash-list
       2008-02-19 20:11:34 /home/einar/today
       2008-02-18 20:11:34 /home/einar/yesterday
       2008-02-10 20:11:34 /home/einar/last_week
       $ trash-empty 7
       $ trash-list
       2008-02-19 20:11:34 /home/einar/today
       2008-02-18 20:11:34 /home/einar/yesterday
       $ trash-empty 1
       $ trash-list
       2008-02-19 20:11:34 /home/einar/today
       $ trash-empty
       $ trash-list
       <none>

BUGS

       Report bugs to http://code.google.com/p/trash-cli/issues

AUTHORS

       Trash  was  written by Andrea Francia <andreafrancia@users.sourceforge.net> and Einar Orn Olason <eoo@hi.is>.  This manual page was written
       by Steve Stalcup <vorian@ubuntu.com>.  Changes made by Massimo Cavalleri <submax@tiscalinet.it>.

SEE ALSO

       trash-put(1), trash-restore(1), trash-list(1), and the FreeDesktop.org Trash Specification at http://www.ramendik.ru/docs/trashspec.html.

       Both are released under the GNU General Public License, version 2 or later.

																    TRASH-EMPTY(1)
All times are GMT -4. The time now is 08:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy