Probaj ovo:
Code:
create table articles (
userCreated varchar(15),
dateCreated date,
homepage varchar(30)
);
INSERT INTO articles (userCreated, dateCreated, homepage) VALUES ('Amazon','2007-05-08','www.amazon.com');
INSERT INTO articles (userCreated, dateCreated, homepage) VALUES ('Yahoo','2007-05-09','www.yahoo.com');
INSERT INTO articles (userCreated, dateCreated, homepage) VALUES ('Google','2007-05-10','www.google.com');
INSERT INTO articles (userCreated, dateCreated, homepage) VALUES ('Pogodak','2007-05-11','www.pogodak.co.yu');
SELECT * FROM articles WHERE homepage LIKE 'www%' ORDER BY dateCreated DESC;
p.s. bez kljuceva, etc., zbog jednostavnosti.
Someone's sitting in the shade today because someone planted a tree a long time ago.