pairs-2, MySQL - rextester

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

select version() as 'mysql version';

DROP TABLE IF EXISTS myTab;

CREATE TABLE IF NOT EXISTS myTab (
	id 			SERIAL PRIMARY KEY,		-- SERIAL alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE
	dateID		DATETIME DEFAULT 0,		-- To be saved as string "yyyy-MM-dd HH:mm:ss"
	name		VARCHAR(512)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO myTab 
    (dateID, name) 
VALUES
    ('2014-08-11', 'Emmy'), /*this*/
    ('2014-09-22', 'Emmy'), /*this*/
    ('2015-09-20', 'Emmy'), /*this*/
    ('2015-09-22', 'Emmy'),
    ('2014-07-22', 'Dave'),
    ('2014-06-13', 'Stan'),
    ('2014-06-22', 'Stan'), /*this*/
    ('2015-10-20', 'Stan'), /*this*/
    ('2014-03-05', 'Lora'),
    ('2014-03-10', 'Lora');

/*ToDo:
  -----
Select all rows with names having multiple dates
when the difference between these dates is more than 1 month
eg: only the entries indicated above *this*
*/

SELECT t.id, t.dateID, t.name 
FROM  myTab AS t
WHERE 
       ( SELECT b.dateID
         FROM myTab AS b
         WHERE t.name = b.name
           AND b.dateID < t.dateID
         ORDER BY b.dateID DESC
         LIMIT 1
       ) + INTERVAL 1 MONTH  <=  t.dateID    
    OR 
       t.dateID + INTERVAL 1 MONTH <= 
       ( SELECT b.dateID
         FROM myTab AS b
         WHERE t.name = b.name
           AND t.dateID < b.dateID
         ORDER BY b.dateID ASC
         LIMIT 1
       )
 ;


absolute service time: 0,31 sec