MySQL BlogPost

CREATE TABLE sqlfiddleusers
(
  id INT auto_increment PRIMARY KEY,
  firstname VARCHAR(20) NOT NULL,
  lastname VARCHAR(20) NOT NULL,
  date_registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO sqlfiddleusers
(firstname, lastname)
values
('Oele','Geirnaert');

CREATE TABLE aLittleTestForOele
    (
     id INT auto_increment PRIMARY KEY,
     user_id INT NOT NULL,
     date_created DATETIME,
     date_last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     contact_type VARCHAR(20) NOT NULL,
     contact_value VARCHAR(50) NOT NULL
    );

INSERT INTO aLittleTestForOele
(User_ID, Date_Created, Contact_Type, Contact_Value)
VALUES
(1,NOW(),'Email', 'mailto:info@oelegeirnaert.be'),
(1,NOW(),'Twitter', 'https://twitter.com/oelegeirnaert'),
(1,NOW(),'Mobile', 'tel:+32479376860'),
(1,NOW(),'Website', 'http://www.oelegeirnaert.be'),
(1,'2003/05/03 21:02:44','Email','AnOldEmailAddress@oelegeirnaert.be'),
(1,NOW(),'LinkedIn','http://www.linkedin.com/in/oelegeirnaert');

SELECT sqlfiddleusers.firstname, sqlfiddleusers.lastname, aLittleTestForOele.contact_type, aLittleTestForOele.contact_value,
  CASE Year(aLittleTestForOele.date_Created)
      WHEN YEAR(NOW()) THEN "YES, up to date!"
      ELSE "Nooooo, what happend?"
  END AS Up_To_Date_Or_Not, Year(aLittleTestForOele.date_Created) AS YEAR_ADDED
FROM sqlfiddleusers
INNER JOIN aLittleTestForOele ON sqlfiddleusers.id = aLittleTestForOele.user_id;

Select 'Thanks For Looking This Example! </br> Kind Regards, \n Oele Geirnaert' AS THANK_YOU;