MySQL SELECT query with conditions

Question

I have a table which looks something like:

id batch_id start_ts stop_ts

I want to select those ids which started yesterday (can be easily done by giving start_ts > .. AND start_ts < ..) and have another id in the table with the same batch_id as the batch_id of this id and that id ended yesterday.

What would be a good way to frame this MySQL query?

user2037828 · Accepted Answer · 2013-02-03 20:19:15Z

2

What about ...

select <field list>  
from table t1
join table t2 on t1.id = t2.batch_id
where start_ts between <date 1> and <date 2>

answered Feb 3, 2013 at 20:19

user2037828

8010 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL SELECT query with conditions

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related