Help On date Format

[rajiv07]

I have table feedback which has three cloumn

Numer(Primary),----update_date, ---------------------- comments
12345 --------------- 2007-01-01,2007-01-02 ------ com1,com2

23455 ----------------- 2007-01-01,2007-01-03 ----- com1,com


Here i have store update_date values as string.so What my problem is if i want to list a set of records between two dates How do i display in case of date are in string Format.Is it Possible.

Is Any idea Please.

Thanks In Advance.

Regards
RajivGandhi

[mwasif]

You can use STR_TO_DATE(). You have 2 date values in the date column, first you have to seperate them and then apply this function.

BTW, why you have stored it in string format?

[rajiv07]

You can use STR_TO_DATE(). You have 2 date values in the date column, first you have to seperate them and then apply this function.

BTW, why you have stored it in string format?

Thank You,and Sorry for the Late reply

Actually i am developing a Customer Feedback System .Here i am storing
the Customer's Comments using their Phone Number.The Phone Number should be unique but the comments and commented Date for that Particular Number might be More than one,so i want to store the comment date(Here i am using date As a String) and Comments,so i have store these value in database separated by comma.But When I want to list out all record using updated date
range the problem will occur.

Thanks
Regards
Rajivgandhi

[mwasif]

If you are expecting more than one comments for a number then this is not a prefered way to store. You should save a seperate record for each comment. In this way you manipulation will be a lot easier. Ofcourse then you can't keep the number as primary key.

Are there only 3 columns in the feedback table?

[rajiv07]

If you are expecting more than one comments for a number then this is not a prefered way to store. You should save a seperate record for each comment. In this way you manipulation will be a lot easier. Ofcourse then you can't keep the number as primary key.

Are there only 3 columns in the feedback table?

Thanks mwasif

There is some more fields in the feedback table.The Table fields Are
feedback Table
---------------------

1.Number(Primary Key).
2.customer_Name.
3.header_msg
4.location.
4.reference
5.storeid.
6.update_date(Here i am using date as a string).
7.comments.


The fields update_date and comments might getting update more than one times.But remaining fields are same.

Can i create new table to store the update_date and corresponding comments using Number.Is it a better way than that. please Let Me know.

Thank U

Regards
Rajivgandhi

[mwasif]

Can i create new table to store the update_date and corresponding comments using Number.Is it a better way than that. please Let Me know.

Good thinking Rajivgandhi. Yes, you should create a new table containing the following fields

Number (as a foreign key)
update_date (date time column)
comments (to save comments)

Now for each comment, you have to insert a new record which will link the feedback table with Number field. And use JOIN to get the records from this table.

Let me know if you need more help.

[rajiv07]

Good thinking Rajivgandhi. Yes, you should create a new table containing the following fields

Number (as a foreign key)
update_date (date time column)
comments (to save comments)

Now for each comment, you have to insert a new record which will link the feedback table with Number field. And use JOIN to get the records from this table.

Let me know if you need more help.

Thanks mwasif,

I going to do that way which you have suggested me.i will ask if i have any doubt on that.

Thank You

RajivGandhi