{"id":957,"date":"2007-09-15T10:15:54","date_gmt":"2007-09-15T07:15:54","guid":{"rendered":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/"},"modified":"2023-06-06T06:57:26","modified_gmt":"2023-06-06T03:57:26","slug":"search-replace-phpmyadminis","status":"publish","type":"post","link":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/","title":{"rendered":"Search & Replace phpMyAdmin’is"},"content":{"rendered":"

Tekkis vajadus \u00fches MySQL baasis, \u00fches tabelis v\u00e4ike search & replace teha.<\/p>\n

\u00dcheks v\u00f5imaluseks on kirjutada vastav PHP skript, mis t\u00f6\u00f6 \u00e4ra teeb. Teine v\u00f5imalus on eksportida vastav tabel, teha asendus oma masinas ja andmed uuesti baasi importida. Kolmas v\u00f5imalus on kasutada phpMyAdmin'i. Mulle tundub praegu see kolmas v\u00f5imalus k\u00f5ige lihtsamana.<\/p>\n

phpMyAdmin'is tuleb valida vajalik andmebaas ja seej\u00e4rel valida ekraanil olevast men\u00fc\u00fcst \"SQL\". Tekkinud kasti tuleb kirjutada p\u00e4ring ja vajutada \"GO\".<\/p>\n

\"phpMyAdmin\"<\/p>\n

P\u00e4ringu tekst on j\u00e4rgmine:<\/p>\n

update [tabeli_nimi] set [v\u00e4lja_nimi] = replace([v\u00e4lja nimi], '[asendatav_string]', '[asendav_string]');<\/p><\/blockquote>\n

Enne igasuguste p\u00e4ringute tegemist teeb kaval baasihaldaja muidugi varukoopia.<\/p>\n

T\u00f5sisele progejale oli see nipp ilmselt juba ammu teada. Kuna mina pole progeja siis ma seda enne ei teadnud. Igatahes s\u00e4\u00e4stis see n\u00f5ks mind ajakulust andmete impordile ja ekspordile. Elu on ikka seiklus!<\/p>\n","protected":false},"excerpt":{"rendered":"

Tekkis vajadus \u00fches MySQL baasis, \u00fches tabelis v\u00e4ike search & replace teha. \u00dcheks v\u00f5imaluseks on kirjutada vastav PHP skript, mis t\u00f6\u00f6 \u00e4ra teeb. Teine v\u00f5imalus on eksportida vastav tabel, teha asendus oma masinas ja andmed uuesti baasi importida. Kolmas v\u00f5imalus…<\/span><\/p>\n

Loe veel ›<\/a><\/div>\n

<\/p>\n","protected":false},"author":1,"featured_media":958,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[2,8,13],"class_list":["post-957","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aarne-bloog","tag-bloog","tag-isetehtud-asjad","tag-teadus"],"yoast_head":"\nSearch & Replace phpMyAdmin'is - Aarne bloog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Search & Replace phpMyAdmin'is - Aarne bloog\" \/>\n<meta property=\"og:description\" content=\"Tekkis vajadus \u00fches MySQL baasis, \u00fches tabelis v\u00e4ike search & replace teha. \u00dcheks v\u00f5imaluseks on kirjutada vastav PHP skript, mis t\u00f6\u00f6 \u00e4ra teeb. Teine v\u00f5imalus on eksportida vastav tabel, teha asendus oma masinas ja andmed uuesti baasi importida. Kolmas v\u00f5imalus…Loe veel ›\" \/>\n<meta property=\"og:url\" content=\"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/\" \/>\n<meta property=\"og:site_name\" content=\"Aarne bloog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/aarne.toompark\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/aarne.toompark\" \/>\n<meta property=\"article:published_time\" content=\"2007-09-15T07:15:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-06T03:57:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/toompark.com\/aarne\/wp-content\/uploads\/2007\/09\/phpmyadmin.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"450\" \/>\n\t<meta property=\"og:image:height\" content=\"156\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Aarne\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Aarne\" \/>\n<meta name=\"twitter:site\" content=\"@Aarne\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aarne\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/\"},\"author\":{\"name\":\"Aarne\",\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/#\\\/schema\\\/person\\\/cad6a11e0fa62991870721d353fe8b1b\"},\"headline\":\"Search & Replace phpMyAdmin’is\",\"datePublished\":\"2007-09-15T07:15:54+00:00\",\"dateModified\":\"2023-06-06T03:57:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/\"},\"wordCount\":153,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/#\\\/schema\\\/person\\\/cad6a11e0fa62991870721d353fe8b1b\"},\"image\":{\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/wp-content\\\/uploads\\\/2007\\\/09\\\/phpmyadmin.jpg\",\"keywords\":[\"Bloog\",\"Isetehtud asjad\",\"Teadus\"],\"articleSection\":[\"Aarne bloog\"],\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/\",\"url\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/\",\"name\":\"Search & Replace phpMyAdmin'is - Aarne bloog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/wp-content\\\/uploads\\\/2007\\\/09\\\/phpmyadmin.jpg\",\"datePublished\":\"2007-09-15T07:15:54+00:00\",\"dateModified\":\"2023-06-06T03:57:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/#primaryimage\",\"url\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/wp-content\\\/uploads\\\/2007\\\/09\\\/phpmyadmin.jpg\",\"contentUrl\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/wp-content\\\/uploads\\\/2007\\\/09\\\/phpmyadmin.jpg\",\"width\":450,\"height\":156},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/search-replace-phpmyadminis\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Aarne bloog\",\"item\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/kategooria\\\/aarne-bloog\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Search & Replace phpMyAdmin’is\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/#website\",\"url\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/\",\"name\":\"Aarne bloog\",\"description\":\"Aarne elu ja tegemised - elu ise\",\"publisher\":{\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/#\\\/schema\\\/person\\\/cad6a11e0fa62991870721d353fe8b1b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/#\\\/schema\\\/person\\\/cad6a11e0fa62991870721d353fe8b1b\",\"name\":\"Aarne\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/aarne-toompark.jpg\",\"url\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/aarne-toompark.jpg\",\"contentUrl\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/aarne-toompark.jpg\",\"width\":500,\"height\":500,\"caption\":\"Aarne\"},\"logo\":{\"@id\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/aarne-toompark.jpg\"},\"sameAs\":[\"https:\\\/\\\/toompark.com\\\/aarne\\\/\",\"https:\\\/\\\/www.facebook.com\\\/aarne.toompark\",\"https:\\\/\\\/www.instagram.com\\\/aarnet\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/aarnetoompark\\\/\",\"https:\\\/\\\/x.com\\\/Aarne\"],\"url\":\"https:\\\/\\\/toompark.com\\\/aarne\\\/author\\\/aarne\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Search & Replace phpMyAdmin'is - Aarne bloog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/","og_locale":"et_EE","og_type":"article","og_title":"Search & Replace phpMyAdmin'is - Aarne bloog","og_description":"Tekkis vajadus \u00fches MySQL baasis, \u00fches tabelis v\u00e4ike search & replace teha. \u00dcheks v\u00f5imaluseks on kirjutada vastav PHP skript, mis t\u00f6\u00f6 \u00e4ra teeb. Teine v\u00f5imalus on eksportida vastav tabel, teha asendus oma masinas ja andmed uuesti baasi importida. Kolmas v\u00f5imalus…Loe veel ›","og_url":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/","og_site_name":"Aarne bloog","article_publisher":"https:\/\/www.facebook.com\/aarne.toompark","article_author":"https:\/\/www.facebook.com\/aarne.toompark","article_published_time":"2007-09-15T07:15:54+00:00","article_modified_time":"2023-06-06T03:57:26+00:00","og_image":[{"width":450,"height":156,"url":"https:\/\/toompark.com\/aarne\/wp-content\/uploads\/2007\/09\/phpmyadmin.jpg","type":"image\/jpeg"}],"author":"Aarne","twitter_card":"summary_large_image","twitter_creator":"@Aarne","twitter_site":"@Aarne","twitter_misc":{"Written by":"Aarne","Est. reading time":"1 minut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/#article","isPartOf":{"@id":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/"},"author":{"name":"Aarne","@id":"https:\/\/toompark.com\/aarne\/#\/schema\/person\/cad6a11e0fa62991870721d353fe8b1b"},"headline":"Search & Replace phpMyAdmin’is","datePublished":"2007-09-15T07:15:54+00:00","dateModified":"2023-06-06T03:57:26+00:00","mainEntityOfPage":{"@id":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/"},"wordCount":153,"commentCount":0,"publisher":{"@id":"https:\/\/toompark.com\/aarne\/#\/schema\/person\/cad6a11e0fa62991870721d353fe8b1b"},"image":{"@id":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/#primaryimage"},"thumbnailUrl":"https:\/\/toompark.com\/aarne\/wp-content\/uploads\/2007\/09\/phpmyadmin.jpg","keywords":["Bloog","Isetehtud asjad","Teadus"],"articleSection":["Aarne bloog"],"inLanguage":"et","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/","url":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/","name":"Search & Replace phpMyAdmin'is - Aarne bloog","isPartOf":{"@id":"https:\/\/toompark.com\/aarne\/#website"},"primaryImageOfPage":{"@id":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/#primaryimage"},"image":{"@id":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/#primaryimage"},"thumbnailUrl":"https:\/\/toompark.com\/aarne\/wp-content\/uploads\/2007\/09\/phpmyadmin.jpg","datePublished":"2007-09-15T07:15:54+00:00","dateModified":"2023-06-06T03:57:26+00:00","breadcrumb":{"@id":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/#primaryimage","url":"https:\/\/toompark.com\/aarne\/wp-content\/uploads\/2007\/09\/phpmyadmin.jpg","contentUrl":"https:\/\/toompark.com\/aarne\/wp-content\/uploads\/2007\/09\/phpmyadmin.jpg","width":450,"height":156},{"@type":"BreadcrumbList","@id":"https:\/\/toompark.com\/aarne\/search-replace-phpmyadminis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/toompark.com\/aarne\/"},{"@type":"ListItem","position":2,"name":"Aarne bloog","item":"https:\/\/toompark.com\/aarne\/kategooria\/aarne-bloog\/"},{"@type":"ListItem","position":3,"name":"Search & Replace phpMyAdmin’is"}]},{"@type":"WebSite","@id":"https:\/\/toompark.com\/aarne\/#website","url":"https:\/\/toompark.com\/aarne\/","name":"Aarne bloog","description":"Aarne elu ja tegemised - elu ise","publisher":{"@id":"https:\/\/toompark.com\/aarne\/#\/schema\/person\/cad6a11e0fa62991870721d353fe8b1b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/toompark.com\/aarne\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":["Person","Organization"],"@id":"https:\/\/toompark.com\/aarne\/#\/schema\/person\/cad6a11e0fa62991870721d353fe8b1b","name":"Aarne","image":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/toompark.com\/aarne\/wp-content\/uploads\/2016\/11\/aarne-toompark.jpg","url":"https:\/\/toompark.com\/aarne\/wp-content\/uploads\/2016\/11\/aarne-toompark.jpg","contentUrl":"https:\/\/toompark.com\/aarne\/wp-content\/uploads\/2016\/11\/aarne-toompark.jpg","width":500,"height":500,"caption":"Aarne"},"logo":{"@id":"https:\/\/toompark.com\/aarne\/wp-content\/uploads\/2016\/11\/aarne-toompark.jpg"},"sameAs":["https:\/\/toompark.com\/aarne\/","https:\/\/www.facebook.com\/aarne.toompark","https:\/\/www.instagram.com\/aarnet\/","https:\/\/www.linkedin.com\/in\/aarnetoompark\/","https:\/\/x.com\/Aarne"],"url":"https:\/\/toompark.com\/aarne\/author\/aarne\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/toompark.com\/aarne\/wp-content\/uploads\/2007\/09\/phpmyadmin.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4ti3-fr","_links":{"self":[{"href":"https:\/\/toompark.com\/aarne\/wp-json\/wp\/v2\/posts\/957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/toompark.com\/aarne\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/toompark.com\/aarne\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/toompark.com\/aarne\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/toompark.com\/aarne\/wp-json\/wp\/v2\/comments?post=957"}],"version-history":[{"count":0,"href":"https:\/\/toompark.com\/aarne\/wp-json\/wp\/v2\/posts\/957\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/toompark.com\/aarne\/wp-json\/wp\/v2\/media\/958"}],"wp:attachment":[{"href":"https:\/\/toompark.com\/aarne\/wp-json\/wp\/v2\/media?parent=957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/toompark.com\/aarne\/wp-json\/wp\/v2\/categories?post=957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/toompark.com\/aarne\/wp-json\/wp\/v2\/tags?post=957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}