Monthly Archives - March 2012

Word Co-occurrence

Lets say we have a database table called responses, each row contains a word. responses Table: id positive response 1 true I have a great experience. I was treated very well. The person was very nice 2 false I had a terrible experience. I was not treated very well. I thought person was very mean. We…

Random Date

Random date, minimum being today max being anything up to 1000 days [code lang=”sql”]</pre> UPDATE tablename SET date = CURDATE() + interval rand()*1000 day <pre>[/code]