dear all, a novice here
quickie regarding query syntax - is it possible to take fields values
from one column
and update the same column with new values like this: prefix_OldValue
column: one, two, three - column: prefix_one, prefix_two, ...
can this be done with one query and with on use of
Something in the ilk of
update *table* set *field* = concat(prefix_, *field*) where *condition *
should do the trick.
On Mon, Oct 19, 2009 at 4:56 PM, lejeczek pelj...@yahoo.co.uk wrote:
dear all, a novice here
quickie regarding query syntax - is it possible to take fields values from
one