Pour rechercher et remplacer une chaîne de caractères directement dans le champ d’une base de données MySQL, il suffit d’utiliser la fonction REPLACE de la manière suivante :
UPDATE [nom_de_la_table] SET [nom_du_champ] =REPLACE([nom_du_champ],’[chaine_a_remplacer]‘,’[chaine_de_remplacement]‘);
Exemple :
UPDATE articles SET content = REPLACE(content,’http://www.mondns.com’,’/’);
…
Posted: octobre 29th, 2011 ˑ
Comments Closed
Filled under:
How-to's,
tech
Top 10 Mobile Web Development JavaScript Frameworks.
…
Posted: septembre 26th, 2011 ˑ
Comments Closed
Filled under:
tech
.::PullRequest.org::. Créer une API REST.
…
Posted: septembre 21st, 2011 ˑ
Comments Closed
Filled under:
tech
12 HTML5 Frameworks for Developers.
…
Posted: mai 31st, 2011 ˑ
Comments Closed
Filled under:
tech
Firebug 1.7 New Features ✩ Mozilla Hacks – the Web developer blog.
DOM Storage
Sort Computed Styles
Better Representation of Attributes
And others……
Posted: mars 26th, 2011 ˑ
Comments Closed
Filled under:
tech
BashPitfalls – Greg’s Wiki. (via @fo0_)…
Posted: décembre 29th, 2010 ˑ
Comments Closed
Filled under:
tech
Ultimate Guide to Microformats: Reference and Examples.
…
Posted: décembre 20th, 2010 ˑ
Comments Closed
Filled under:
tech
Base64 Encoding for Images..
…
Posted: novembre 16th, 2010 ˑ
Comments Closed
Filled under:
tech