How to compare the values in a timestamp column with the user input using MySQL -

How to compare the values in a timestamp column with the user input using MySQL -

i have table contains timestamp column.

i need compare values in timestamp column user input , extract whole row table.

timestamp column

29-10-14 07:20:01.00000 26-10-14 07:20:01.00000 27-10-14 07:20:01.00000 28-10-14 10:00:00.00000

i tried below line in clause

to_char(timestampcol,'dd-mon-yy hh12:mi:ss')= to_char(sysdate,'dd-mon-yy 10:00:00')

but dint succeed. please help.

thanks in advance,

shreyas athreya s

mysql