select * from your_table
where `time` between date_sub(now(), interval 1 day) and now();

• Mysql Query for breaking unix time stamp into periods

  I have a database table named posts in which there are 3 fields like : post_id (int, autoincrement, primary) post_text (varchar 200) post_time (int) I am using the following mysql que…

• mysql query to get data from various time periods

  SELECT COUNT(t1.tid) AS count, u.user_name, SEC_TO_TIME(SUM(TIME_TO_SEC(TIMEDIFF(t1.endtime,t1.endtime)))/COUNT(t1.endtime)) AS `avg`, MAX(TIMEDIFF(t1.endtime,t1.starttime)) AS `max`…

• MySQL Querying database for time periods not already assigned

  I have a rather complex-seeming query that will form the basis for an online classroom scheduling tool. My challenge is to develop a method to identify which classes a user is signed up for in the s…

• mySQL query for selecting children

  I am not sure if this is possible in mySQL. Here are my tables:- Categories table - id - name - parent_id (which points to Categories.id) I use the above table to map all the categories and su…

• SQL query to obtain an Average value for set periods of time

  I have a MySQL database which is used to store power readings, with a reading added once per minute. (i.e. 1,440 readings per day). time power ---- ----- 00:00:00 346 00:01:00 352 00:02:00 …

• MySQL selecting time period

  I have a table called away with the following fields +---------------+-----------------+---------------+ | Name | from | to | +---------------+-----------------+---------------+ | L…

• mysql. sql query. selecting

  there is a table with columns: id, artist, title, album. i need to get rows with different values of pair (artist, title) and album example: i have now (result of my query): ===artist ======…

• Mysql query for selecting name based on condition

  Users UserGroup id name rowid GrpID UserID name 1 aaa 1 1 1 aaa 2 bbb 2 1 3 ccc 3 ccc 3 2 1 aaa 4 ddd 4 2 4 ddd 5 eee 5 2 5 …

• MySQL query string for selecting certain row with a id

  I have a MySQL db, and I needed to know what query should I use for selecting the row whith the ID I tell it: An example row: TITLE: test DATE: 01/01/01 01:01 CONTENT: test content ID: 5 H…

• Best practices for storing & selecting time/date with php & mysql?

  I often find myself storing data in a mysql database, and then wanting to display all sorts of stats about my data, specifically stuff like 'how many rows do I have for this date, or that date'. …