List:General Discussion« Previous MessageNext Message »
From:lejeczek Date:October 19 2009 2:56pm
Subject:update fields with a prefix - ?? how to
View as plain text  
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 abstractions, no php 
or similar scripting techincs?

cheers, lejeczek
update fields with a prefix - ?? how tolejeczek19 Oct
  • Re: update fields with a prefix - ?? how toJohan De Meersman19 Oct