how to covert varchar type to timestamp on mysql query.

[slackman]

i have database for store the personel detail such as name ,lastname, and birthday

name varchar
lastname varchar
birthday varchar

but i want to query birthday by order DESC.

" select * from userdata order by birthday DESC "

that query syntax not working (i think becuase i store birthday in varchar type)

!! How to arrange birthday by order DESC.

condition
1. i need store birthday filed in varchar type only.
2. i write code on php.

[kyku]

MySQL AB :: MySQL 5.0 Reference Manual :: 12.6 Date and Time Functions Use the function to convert varchar to date in your ORDER BY condition