Does anyone know how I can change every record in a database with a cat of latest news to latest?
update mytable set cat = '$latestcat'
should do it.
However I would be inclined to question your design!