edited,
kestrel > select title, author, productgroup, dateadded from dvds where dateadded like '%2006-07-08%'; +------------------------------------------------------+------------------------+--------------+---------------------+ | title | author | productgroup | dateadded | +------------------------------------------------------+------------------------+--------------+---------------------+ | Good Night and Good Luck [2005] | | DVD | 2006-07-08 17:53:22 | | O-Zone | Paul Theroux | Book | 2006-07-08 17:50:26 | | The Business | Iain Banks | Book | 2006-07-08 17:49:50 | | To Kill a Mockingbird | Harper Lee | Book | 2006-07-08 17:49:22 | | We Are Still Married | Garrison Keillor | Book | 2006-07-08 17:48:43 | | Charlotte Gray | Sebastian Faulks | Book | 2006-07-08 17:48:28 | | One Hundred Years of Solitude (Essential.penguin S.) | Gabriel Garcia Marquez | Book | 2006-07-08 17:48:13 | | 44 Scotland Street | Alexander McCall Smith | Book | 2006-07-08 17:47:52 | | Automated Alice | Jeff Noon | Book | 2006-07-08 17:47:26 | | Man and Boy | Tony Parsons | Book | 2006-07-08 17:47:09 | | Accordion Crimes | Annie Proulx | Book | 2006-07-08 17:46:46 | | A Change of Climate | Hilary Mantel | Book | 2006-07-08 17:46:25 | +------------------------------------------------------+------------------------+--------------+---------------------+ 12 rows in set (0.21 sec)
the DVD came from Costco this morning, the books from the Rotary Club second hand bookstall in Nailsea; the latter were only 50p a shot, so I think we can be forgiven.
I very much enjoyed O-Zone, but I know no-one else that has read it! Banks seems to have lost his way though.
“The Business” is a few years old. Interesting. I dunno about “Lost his way” – he goes off in experimental directions. Have you read The Algebraist? Right on form if you ask me. 🙂
create table MEDIA { title VARCHAR 100 author VARCHAR 100 productgroup CHAR 30 dateadded DATETIME } insert into MEDIA values (select * from DVD) drop table DVDwhere’s your primary key, then?
RENAME TABLE dvds TO MEDIA
‘ass ‘a bleedin’ problem wif yer yoof of today. No respeck’ for traditional values. Bring back Nashnul Service, I say.