<div>How about something like:</div><div><br></div><div><br></div><div>update <b><tablename></b> set system_num='<b><number_you_want></b>' where system_num='<b><number it is>';</b></div><div>
<br></div><div><br></div><div>Is that what you're looking for?</div><div><br></div><div><br></div><div><br></div><br clear="all">---<br>Jerald M. Sheets jr.<br><br><br>
<br><br><div class="gmail_quote">On Fri, Jul 23, 2010 at 11:34 AM, david w. millians <span dir="ltr"><<a href="mailto:millia@panix.com">millia@panix.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
Okay, I'm trying to fix a database issue. I have a table:<br>
users<br>
with fields<br>
last, first, etc.<br>
Of interest is the field system_num. In the old system, this was the ID<br>
field from another table, that pointed to the proper value. In the new<br>
system, that ID field is the proper value.<br>
So how do I do a search and replace? I did RTFM somewhat and discovered<br>
the replace function. It did replace, but also had the unintended<br>
consequence of messing things up since the replace is not for the whole<br>
field but is instead for any matching string in the field.<br>
<br>
How do you do this for the whole field?<br>
_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
</blockquote></div><br>