Date: 11/14/06 (MySQL Communtiy)    Keywords: php

Hi, I am using phpmyadmin's search to find bad data. The data is WAY too long to search manually.

What I am basically looking for is when the start_time has seconds in it. Such as 01:00:05. (01:00:00 is good data). I am looking for all instances where the seconds are not equal to zero.

Lil' help with the query?


SOLVED: See comments.

Source: http://community.livejournal.com/mysql/106501.html