Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.
I consider this a bug, beacause it is OK in MySQL to do a LIKE on a date with the % wildcard, so why should it not be possible with phpMyAdmin?
Margus Lind (modulo)
Removed the constraint.
Note that this also removes the constraint form other input boxes for datetimes and timestamps like entering new data.
If the data is not in a valid form the user will receive an error from MySQL.
There never was validation for this therefore but this would allow the user to enter valid dates in an unsupported format.
Is a profitable trade-off (allowing % searches through the UI vs being able to enter seemingly valid dates)?