<pre>mysql> select exp_name, dateobs, exp_type, fault from summitExp where fault >0; +-------------+---------------------+----------+-------+ | exp_name | dateobs | exp_type | fault | +-------------+---------------------+----------+-------+ | c4583g0055d | 2008-04-27 21:48:11 | DARK | 110 | | c4584g0002d | 2008-04-28 01:14:19 | DARK | 110 | | c4584g0003d | 2008-04-28 01:41:42 | DARK | 110 | | c4584g0004d | 2008-04-28 01:49:50 | DARK | 110 | | c4584g0006d | 2008-04-28 03:50:02 | DARK | 110 | | c4584g0010o | 2008-04-28 05:39:10 | DARK | 110 | | c4596g0001o | 2008-05-10 10:09:00 | OBJECT | 110 | | c4601g0095o | 2008-05-15 01:24:23 | OBJECT | 110 | | c4601g0107o | 2008-05-15 01:27:46 | OBJECT | 110 | | c4601g0109o | 2008-05-15 01:41:52 | OBJECT | 110 | | c4601g0160o | 2008-05-15 01:55:12 | OBJECT | 110 | | c4606g0002f | 2008-05-20 05:20:47 | DOMEFLAT | 110 | | c4606g0003f | 2008-05-20 05:30:05 | DOMEFLAT | 110 | | o4594g0007o | 2008-05-08 10:15:45 | OBJECT | 110 | | o4596g0147o | 2008-05-10 09:14:20 | OBJECT | 110 | | o4596g0148o | 2008-05-10 09:18:54 | OBJECT | 110 | | o4596g0149o | 2008-05-10 09:22:48 | OBJECT | 110 | | o4596g0150o | 2008-05-10 09:27:26 | OBJECT | 110 | | o4596g0152o | 2008-05-10 09:58:59 | OBJECT | 110 | | o4599g0067o | 2008-05-13 06:49:37 | OBJECT | 110 | | o4605g0153o | 2008-05-19 11:51:16 | OBJECT | 110 | | o4614g0033o | 2008-05-28 08:01:13 | OBJECT | 110 | | o4614g0034o | 2008-05-28 08:02:40 | OBJECT | 110 | | o4614g0035o | 2008-05-28 08:04:06 | OBJECT | 110 | | o4614g0036o | 2008-05-28 08:05:05 | OBJECT | 110 | | o4614g0037o | 2008-05-28 08:05:52 | OBJECT | 110 | +-------------+---------------------+----------+-------+ 26 rows in set (0.00 sec) </pre>