Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Unanswered: Clean up TEXT column

    I have nothing but enter key in my TEXT column.
    what is the faster way to clean it up?
    thanks for the help
    Attached Thumbnails Attached Thumbnails cleanup.jpg  

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Have you tried using REPLACE:

    Code:
    UPDATE stock SET cstkmemo = REPLACE(cstkmemo, "\n", "");
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •