{"id":6346,"date":"2014-06-09T06:46:47","date_gmt":"2014-06-09T06:46:47","guid":{"rendered":"https:\/\/www.jose-aguilar.com\/blog\/?p=6346"},"modified":"2016-05-17T14:00:28","modified_gmt":"2016-05-17T14:00:28","slug":"buscar-y-reemplazar-en-mysql","status":"publish","type":"post","link":"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/","title":{"rendered":"Buscar y reemplazar en MySQL"},"content":{"rendered":"<p>A medida que pasa el tiempo y un programador va cogiendo experiencia siempre llegar\u00e1 el momento de tener que realizar un cambio brusco o actualizaci\u00f3n de registros masivo en la base de datos.<\/p>\n<p>En este art\u00edculo vamos a ver como buscar y reemplazar un valor en una tabla de la base de datos y reemplazar ese valor por otro.<\/p>\n<p>En el ejemplo que vamos a ilustrar nos vamos a centrar en la base de datos de un Prestashop y vamos a querer buscar la palabra <em>diseno<\/em> y reemplazarla por dise\u00f1o en el campo de descripciones cortas de los productos en el lenguage espa\u00f1ol.<\/p>\n<pre lang=\"sql\">UPDATE ps_product_lang\r\nSET description_short = replace(description_short, 'diseno', 'dise\u00f1o')\r\nWHERE id_lang=1\r\n<\/pre>\n<p>La funci\u00f3n replace() de SQL nos permite conseguir el efecto de reemplazar la palabra <em>diseno<\/em> por <em>dise\u00f1o<\/em>. Esta funci\u00f3n recibe 3 par\u00e1metros: el campo donde se va a realizar la acci\u00f3n, el string buscado y el string que reemplazar\u00e1 al buscado.<\/p>\n<p>De esta forma no tendremos que ir producto por producto editando su descripci\u00f3n corta. En cuesti\u00f3n de segundos podemos actualizar miles de registros. Realizar esta tarea sin conocimientos de base de datos tardar\u00edamos muchas horas.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A medida que pasa el tiempo y un programador va cogiendo experiencia siempre llegar\u00e1 el momento de tener que realizar un cambio brusco o actualizaci\u00f3n de registros masivo en la base de datos. En este art\u00edculo vamos a ver como buscar y reemplazar un valor en una tabla de la base de datos y reemplazar [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6016,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,21],"tags":[],"class_list":["post-6346","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-prestashop"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Buscar y reemplazar en MySQL - Jose Aguilar Blog<\/title>\n<meta name=\"description\" content=\"En este art\u00edculo vamos a ver como buscar y reemplazar un valor en una tabla de la base de datos y reemplazar ese valor por otro.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Buscar y reemplazar en MySQL - Jose Aguilar Blog\" \/>\n<meta property=\"og:description\" content=\"En este art\u00edculo vamos a ver como buscar y reemplazar un valor en una tabla de la base de datos y reemplazar ese valor por otro.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Jose Aguilar Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/joseaguilarblog\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-09T06:46:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-05-17T14:00:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"225\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jose Aguilar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:site\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jose Aguilar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/\",\"name\":\"Buscar y reemplazar en MySQL - Jose Aguilar Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg\",\"datePublished\":\"2014-06-09T06:46:47+00:00\",\"dateModified\":\"2016-05-17T14:00:28+00:00\",\"author\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\"},\"description\":\"En este art\u00edculo vamos a ver como buscar y reemplazar un valor en una tabla de la base de datos y reemplazar ese valor por otro.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/#primaryimage\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg\",\"contentUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg\",\"width\":300,\"height\":225},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.jose-aguilar.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Buscar y reemplazar en MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/\",\"name\":\"Jose Aguilar Blog\",\"description\":\"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\",\"name\":\"Jose Aguilar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"caption\":\"Jose Aguilar\"},\"description\":\"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.\",\"sameAs\":[\"https:\/\/plus.google.com\/114357189801512615537\"],\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Buscar y reemplazar en MySQL - Jose Aguilar Blog","description":"En este art\u00edculo vamos a ver como buscar y reemplazar un valor en una tabla de la base de datos y reemplazar ese valor por otro.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"es_ES","og_type":"article","og_title":"Buscar y reemplazar en MySQL - Jose Aguilar Blog","og_description":"En este art\u00edculo vamos a ver como buscar y reemplazar un valor en una tabla de la base de datos y reemplazar ese valor por otro.","og_url":"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/","og_site_name":"Jose Aguilar Blog","article_publisher":"https:\/\/www.facebook.com\/joseaguilarblog","article_published_time":"2014-06-09T06:46:47+00:00","article_modified_time":"2016-05-17T14:00:28+00:00","og_image":[{"width":300,"height":225,"url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg","type":"image\/jpeg"}],"author":"Jose Aguilar","twitter_card":"summary_large_image","twitter_creator":"@JoseAguilarBlog","twitter_site":"@JoseAguilarBlog","twitter_misc":{"Escrito por":"Jose Aguilar","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/","url":"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/","name":"Buscar y reemplazar en MySQL - Jose Aguilar Blog","isPartOf":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg","datePublished":"2014-06-09T06:46:47+00:00","dateModified":"2016-05-17T14:00:28+00:00","author":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11"},"description":"En este art\u00edculo vamos a ver como buscar y reemplazar un valor en una tabla de la base de datos y reemplazar ese valor por otro.","breadcrumb":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/#primaryimage","url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg","contentUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg","width":300,"height":225},{"@type":"BreadcrumbList","@id":"https:\/\/www.jose-aguilar.com\/blog\/buscar-y-reemplazar-en-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.jose-aguilar.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Buscar y reemplazar en MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.jose-aguilar.com\/blog\/#website","url":"https:\/\/www.jose-aguilar.com\/blog\/","name":"Jose Aguilar Blog","description":"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11","name":"Jose Aguilar","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","caption":"Jose Aguilar"},"description":"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.","sameAs":["https:\/\/plus.google.com\/114357189801512615537"],"url":"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/"}]}},"_links":{"self":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/6346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/comments?post=6346"}],"version-history":[{"count":0,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/6346\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media\/6016"}],"wp:attachment":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media?parent=6346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/categories?post=6346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/tags?post=6346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}