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

Making multiple rows with one query
I have a table called efed_handler_characters with two fields handler_id and bio_id. What query 2 is

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

Inserting into MySQL Newbie
Hi ive got a slight problem where ive made a simple web form where the customer inserts the ammount

mysql select query problem
how can i select multiple fields from multiple table in one query like

i have table name t1 a

Operator precedence assistance.
I did a quick Google search and couldn't quite find the answer I wanted in terms I could understand,

Ariba 9r - SAP MM Integration
Hi experts,

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

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

need help in creating captcha
hi i have a problem creating captcha system. i create some basic script for image displaying but it

sql error
I have been looking at this code for 20mins and can't work out what I am doing wrong. There is somet

Syntax Help
I'm trying to make a form that edits a php file which contains config settings. I'm using strings t