List:General Discussion« Previous MessageNext Message »
From:spacemarc Date:December 5 2008 8:32pm
Subject:Re: SELECT with replacement chars
View as plain text  
thanks, it works fine (on mysql 4 and 5)


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



-- 
Scripts: http://www.spacemarc.it
Thread
SELECT with replacement charsspacemarc5 Dec
  • RE: SELECT with replacement charsOFT)5 Dec
  • RE: SELECT with replacement charsJerry Schwartz5 Dec
    • Re: SELECT with replacement charsspacemarc5 Dec