> Is it possible to enforce data formatting in fields using something like
> a regular expression?
> varchar is great but does not stop someone putting in the wrong
> reference number.
Dates should be in a DATE column, not a varchar.
> I suspect the answer is no, you have to do it at a higher level. What
> aprroach would people suggest?
> Perhaps another table with two fields - field_name and field_regex?
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!