{"id":117,"date":"2007-02-26T09:22:13","date_gmt":"2007-02-25T23:22:13","guid":{"rendered":"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/"},"modified":"2007-02-26T09:24:07","modified_gmt":"2007-02-25T23:24:07","slug":"remove-the-first-character-in-mysql","status":"publish","type":"post","link":"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/","title":{"rendered":"Remove the first character in mysql"},"content":{"rendered":"<pre>UPDATE `tablename`\r\nSET `columnname` = \r\nTRIM(LEADING  'THE CHARACTER YOU WANT TO REMOVE, eg: A'  FROM `columnname`);<\/pre>\n<pre>TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str)<\/pre>\n<p>Returns the string str with all remstr prefixes or suffixes removed. If none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is assumed. remstr is optional and, if not specified, spaces are removed.<\/p>\n<pre>\r\nmysql> SELECT TRIM('  bar   ');\r\n        -> 'bar'\r\nmysql> SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx');\r\n        -> 'barxxx'\r\nmysql> SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx');\r\n        -> 'bar'\r\nmysql> SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz');\r\n        -> 'barx'\r\n<\/pre>\n<p>This function is multi-byte safe.  <\/p>\n<p>Source: <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/string-functions.html\">MySQL 5.0 Reference Manual<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>UPDATE `tablename` SET `columnname` = TRIM(LEADING &#8216;THE CHARACTER YOU WANT TO REMOVE, eg: A&#8217; FROM<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-117","post","type-post","status-publish","format-standard","hentry","category-snippets"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Remove the first character in mysql | Tech Leadership Advice &amp; Resources<\/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:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Remove the first character in mysql | Tech Leadership Advice &amp; Resources\" \/>\n<meta property=\"og:description\" content=\"UPDATE `tablename` SET `columnname` = TRIM(LEADING &#039;THE CHARACTER YOU WANT TO REMOVE, eg: A&#039; FROM\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Tech Leadership Advice &amp; Resources\" \/>\n<meta property=\"article:published_time\" content=\"2007-02-25T23:22:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2007-02-25T23:24:07+00:00\" \/>\n<meta name=\"author\" content=\"Isabel Nyo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Isabel Nyo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/\"},\"author\":{\"name\":\"Isabel Nyo\",\"@id\":\"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/33457dd19f1ad9bbd4b0cb50c54dfcab\"},\"headline\":\"Remove the first character in mysql\",\"datePublished\":\"2007-02-25T23:22:13+00:00\",\"dateModified\":\"2007-02-25T23:24:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/\"},\"wordCount\":50,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/33457dd19f1ad9bbd4b0cb50c54dfcab\"},\"articleSection\":[\"Snippets\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/\",\"url\":\"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/\",\"name\":\"Remove the first character in mysql | Tech Leadership Advice &amp; Resources\",\"isPartOf\":{\"@id\":\"https:\/\/eisabainyo.net\/weblog\/#website\"},\"datePublished\":\"2007-02-25T23:22:13+00:00\",\"dateModified\":\"2007-02-25T23:24:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eisabainyo.net\/weblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Remove the first character in mysql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/eisabainyo.net\/weblog\/#website\",\"url\":\"https:\/\/eisabainyo.net\/weblog\/\",\"name\":\"Career Resources for Professionals in Tech\",\"description\":\"Books, worksheets, templates, frameworks and other useful resources for Chief Technology Officers (CTOs), VPs of Engineering &amp; Technology Directors\",\"publisher\":{\"@id\":\"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/33457dd19f1ad9bbd4b0cb50c54dfcab\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/eisabainyo.net\/weblog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/33457dd19f1ad9bbd4b0cb50c54dfcab\",\"name\":\"Isabel Nyo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3d4b1a4e0f425adb39b242b0d62c5fac07c82f8314a24631f1d16f47bdf006d8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3d4b1a4e0f425adb39b242b0d62c5fac07c82f8314a24631f1d16f47bdf006d8?s=96&d=mm&r=g\",\"caption\":\"Isabel Nyo\"},\"logo\":{\"@id\":\"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/image\/\"},\"description\":\"My interests: Web Development, Web Design, Web Applications, Web 2.0, AJAX, Search Engine Optimisation, Latest Technologies and more..\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Remove the first character in mysql | Tech Leadership Advice &amp; Resources","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:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Remove the first character in mysql | Tech Leadership Advice &amp; Resources","og_description":"UPDATE `tablename` SET `columnname` = TRIM(LEADING 'THE CHARACTER YOU WANT TO REMOVE, eg: A' FROM","og_url":"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/","og_site_name":"Tech Leadership Advice &amp; Resources","article_published_time":"2007-02-25T23:22:13+00:00","article_modified_time":"2007-02-25T23:24:07+00:00","author":"Isabel Nyo","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Isabel Nyo","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/#article","isPartOf":{"@id":"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/"},"author":{"name":"Isabel Nyo","@id":"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/33457dd19f1ad9bbd4b0cb50c54dfcab"},"headline":"Remove the first character in mysql","datePublished":"2007-02-25T23:22:13+00:00","dateModified":"2007-02-25T23:24:07+00:00","mainEntityOfPage":{"@id":"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/"},"wordCount":50,"commentCount":1,"publisher":{"@id":"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/33457dd19f1ad9bbd4b0cb50c54dfcab"},"articleSection":["Snippets"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/","url":"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/","name":"Remove the first character in mysql | Tech Leadership Advice &amp; Resources","isPartOf":{"@id":"https:\/\/eisabainyo.net\/weblog\/#website"},"datePublished":"2007-02-25T23:22:13+00:00","dateModified":"2007-02-25T23:24:07+00:00","breadcrumb":{"@id":"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/eisabainyo.net\/weblog\/2007\/02\/26\/remove-the-first-character-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eisabainyo.net\/weblog\/"},{"@type":"ListItem","position":2,"name":"Remove the first character in mysql"}]},{"@type":"WebSite","@id":"https:\/\/eisabainyo.net\/weblog\/#website","url":"https:\/\/eisabainyo.net\/weblog\/","name":"Career Resources for Professionals in Tech","description":"Books, worksheets, templates, frameworks and other useful resources for Chief Technology Officers (CTOs), VPs of Engineering &amp; Technology Directors","publisher":{"@id":"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/33457dd19f1ad9bbd4b0cb50c54dfcab"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/eisabainyo.net\/weblog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/33457dd19f1ad9bbd4b0cb50c54dfcab","name":"Isabel Nyo","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3d4b1a4e0f425adb39b242b0d62c5fac07c82f8314a24631f1d16f47bdf006d8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3d4b1a4e0f425adb39b242b0d62c5fac07c82f8314a24631f1d16f47bdf006d8?s=96&d=mm&r=g","caption":"Isabel Nyo"},"logo":{"@id":"https:\/\/eisabainyo.net\/weblog\/#\/schema\/person\/image\/"},"description":"My interests: Web Development, Web Design, Web Applications, Web 2.0, AJAX, Search Engine Optimisation, Latest Technologies and more.."}]}},"_links":{"self":[{"href":"https:\/\/eisabainyo.net\/weblog\/wp-json\/wp\/v2\/posts\/117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eisabainyo.net\/weblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eisabainyo.net\/weblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eisabainyo.net\/weblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eisabainyo.net\/weblog\/wp-json\/wp\/v2\/comments?post=117"}],"version-history":[{"count":0,"href":"https:\/\/eisabainyo.net\/weblog\/wp-json\/wp\/v2\/posts\/117\/revisions"}],"wp:attachment":[{"href":"https:\/\/eisabainyo.net\/weblog\/wp-json\/wp\/v2\/media?parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eisabainyo.net\/weblog\/wp-json\/wp\/v2\/categories?post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eisabainyo.net\/weblog\/wp-json\/wp\/v2\/tags?post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}