Update of /var/cvs/contributions/CMSContainer
In directory james.mmbase.org:/tmp/cvs-serv23701
Modified Files:
MYSQL.txt
Log Message:
replace value sql
See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer
Index: MYSQL.txt
===================================================================
RCS file: /var/cvs/contributions/CMSContainer/MYSQL.txt,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -b -r1.4 -r1.5
--- MYSQL.txt 1 Aug 2007 15:07:00 -0000 1.4
+++ MYSQL.txt 21 Jun 2008 12:35:54 -0000 1.5
@@ -54,3 +54,6 @@
show variables
max_allowed_packet
\ No newline at end of file
+
+// update value with replacement string
+UPDATE <table> SET <field_name> = replace(<field_name>, 'old', 'new');
\ No newline at end of file
_______________________________________________
Cvs mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/cvs
