Don't ask to ask, just ask | |
PerlMonks |
Re: Match similar textby pboin (Deacon) |
on Sep 08, 2003 at 13:46 UTC ( [id://289769]=note: print w/replies, xml ) | Need Help?? |
First thing I'd suggest is to do what you can to stop more bad entries. Make sure to implement validation of one kind or another so this is a one-time problem. Then, if it were me (it's not, but play along), I'd follow Sport's suggestion, and do a one-time select on unique state values, then find the mis-spellings you have, and make appropriate update statements. It's low-tech, but there's definitely a time and place for that. This should be a one-timer.
In Section
Seekers of Perl Wisdom
|
|