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?
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)?
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.