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)

Your Answer:

Login to answer

Other forums

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

Showing selected item at top of list
Hi,

I've got a list of names which i am fetching from database like this:
$qry = db_query

check comment for html
hi, I just wanted to check if a comment a user posts contains HTML, and if it does, to not allow it

Multipe Dynamic Controls & AutoPostback Issue
I currently have a need to create many dynamic controls (Example Textboxes) that need to do a PostBa

Option box to change variable
Hello, i need help by making a script!

I need to write a file with option box, so a dropdown

Keep newlines from textarea?..
I'm creating a simple encoding program, and what I want it to do is retain the newlines, as echoing

Ariba 9r - SAP MM Integration
Hi experts,

The standard Ariba adapter for 9r creates a relationship between Cost Centers

Getting rid of quotes when printing data
Hi Guys, I use the filter_var FILTER_SANITIZE_STRING to filter the textarea input. The function esca

LinkedList help
Ok so I just learned quickly about lists, so I have a not too hard project I think, but am having a

GET * FROM _____ Except?
I have a site that is for stock photography.

This section of the code calls images to display