Baron Schwartz wrote:
> Tim Milstead wrote:
>> 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.
>> 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?
> If you are using 5.x or greater, you can do some kinds of data
> validation with a trigger.
I would argue that your data-validation should really not be done with
triggers - I would look more at the php/asp/whatever code to do this.
Shouldn't this be more efficient than using triggers? At the very least
doing validation on the web server will make it easier to add capacity
with multiple web servers.