MySQL query to get same column data in two rows
SELECT 1 Start, t1.time `Start Time`, 0 Stop, MIN(t2.time) `Stop Time`
FROM src_table t1
JOIN src_table t2 ON t2.time &gt; t1.time AND t2.ign = 0
GROUP BY t1.time
WHERE t1.ign = 1