{"id":889,"date":"2020-11-05T20:17:54","date_gmt":"2020-11-05T20:17:54","guid":{"rendered":"https:\/\/dapliw.org\/?p=889"},"modified":"2020-11-05T20:17:54","modified_gmt":"2020-11-05T20:17:54","slug":"sql-borrar-registros-tabla-que-contengan-una-cadena-de-caracteres-con-comodin","status":"publish","type":"post","link":"https:\/\/saemas.com\/sitio_web\/sql-borrar-registros-tabla-que-contengan-una-cadena-de-caracteres-con-comodin\/","title":{"rendered":"SQL &#8211; Borrar registros de tabla que contengan una cadena de caracteres con comod\u00edn"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-924 aligncenter\" src=\"https:\/\/dapliw.org\/wp-content\/uploads\/2020\/11\/borrarConLapiz-300x229.png\" alt=\"\" width=\"300\" height=\"229\" \/><\/p>\n<p>Usamos DELETE:<\/p>\n<pre><code>DELETE FROM 'nombre_tabla' WHERE nombre_fila like '%cadena%'<\/code><\/pre>\n<div class=\"sql-highlight cm-s-default\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Usamos DELETE: DELETE FROM &#8216;nombre_tabla&#8217; WHERE nombre_fila like &#8216;%cadena%&#8217;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"material-hide-sections":[],"footnotes":""},"categories":[45],"tags":[46],"class_list":["post-889","post","type-post","status-publish","format-standard","hentry","category-sql","tag-sql"],"_links":{"self":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/posts\/889","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/comments?post=889"}],"version-history":[{"count":0,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/posts\/889\/revisions"}],"wp:attachment":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/media?parent=889"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/categories?post=889"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/tags?post=889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}