PING: MySQL gurus

[cartman]

My string manipulation fu is weak. I've got a field where the first character of every record is \n, the newline character. I'm trying to remember how to update the table to remove these characters, and I'm drawing blanks. Any help is appreciated.

[Antmeister]

Try this:
http://www.zimmertech.com/tutorials/php/60/mysql-search-replace-phpmyadmin.php

[cartman]

Thanks! That did the trick. I kept trying LTRIM and all that jazz, but this way is much simpler.