At 8:23 AM +1100 11/12/02, Daniel Kasak wrote:
Alex Pilson wrote:
I am stumped on how to create a statement that will find all
instances of a field (price) and change the .98 to .99. Looking
through the MySQL book of P. Dubois, it seems I need to do pattern
matching but I can't figure out how to combine the statement into
an UPDATE.
Doea anyone have an off - the shelf query for something like this?
update MyTable set price=price+.01 where price like '%.98'
Wow, I must have been over thinking it, this was simple.
Thanks big time!
--
<--------------------------------------------------------------->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.8225 CELL
<--------------------------------------------------------------->
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
