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
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
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