Re: SELECT with replacement chars

[spacemarc]

thanks, it works fine (on mysql 4 and 5)


> SELECT CONCAT(LEFT(myfield,LENGTH(myfield) - 3), '***') FROM table;



-- 
Scripts: http://www.spacemarc.it

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]