Updating text that ends with...

2002-11-11 Thread Alex Pilson
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

Re: Updating text that ends with...

2002-11-11 Thread Daniel Kasak
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

Re: Updating text that ends with...

2002-11-11 Thread Alex Pilson
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