Select records having a datetime one second apart from each other

    Date: 09/25/08 (MySQL Communtiy)    Keywords: no keywords

    I have a small (250,000 records) table with data and a datetimefield. Most datetime fields are several minutes or days apart, but some are literally one second apart. How would I query the table to show only those rows?

    Source: http://mysql.livejournal.com/131659.html

« Efficient full-text searchs... || Find datetimes with time of... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home