MySQL noob question


Posted on 16th Feb 2014 07:03 pm by admin

hi guys

I have a simple mysql table set up, along the lines of

Col 1 - Col 2 - Date_last_updated
--------------------------------
Som - Some - 06/11/2009 23:23:23
Bob - Bob - 06/11/2009 23:30:30


and so on...

I am trying to put an mysql statement together that reads along the lines of

SELECT * FROM table WHERE (date_last_updated > 01/01/01 23:23:23) AND (date_last_updated < 02/01/01 00:00:00)


how do I go about doing this?

thanks

(hope I was clear and concise)

No comments posted yet

Your Answer:

Login to answer
223 Like 46 Dislike
Previous forums Next forums
Other forums

need to apply an if/else statement to Tim Thumb script
Not sure how to work this. I essentially want to call a variety of image sizes based on which style

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to

PHP mail() rejected by SMTP
I'm currently working on a newsletter application which is installed on a windows 2003 server runnin

PHP/PKI
I am trying to set up a web application that uses pki. does anyone have a good tutorial to set this

UTL File problem
Hi
I have a file in certain path with the following permissions (The file is a dummy file witho

Not capturing all the information we require in the form.......
Hi Guys,

I was wondering if you would share some more of your knowledge today, I'm hoping it

background color imagefill
Hello

I would like to ask you why I see this square in red color just in my local xampp insta

Unidentified index error in a simple form
I have been trying to make an HTML form that is handled by a PHP script. So far my attempts to get i

How to get exact 3 moths post date from today date using javascript
How to get exact 3 moths post date from today date using javascript
Please help

Script not running properly
Hello Everyone
This is a basic script for posting to a database. I'm not sure why it doesn't work

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash