Re: underscore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Hi Ryanne,

On Thursday, January 30, 2003, at 04:09  PM, ryanne cruz wrote:

i have a column wherein a lot of entries has 2 or more names int it. these are separated by spaces. an example is: "John Doe", "Mary Margaret Smith". i need
to replace the spaces with an underscore. any idea how to do this?


In PHP use preg_replace (http://php.net/preg_replace for details)

In PostgreSQL use replace(string text, from text, to text)

(http://www.postgresql.org/docs/ view.php?version=7.3&idoc=1&file=functions-string.html)

To update a column in a table, you could do something like:

UPDATE table SET column = REPLACE( column, ' ', '_' );

Matthew.

--
Matthew Horoschun
Network Administrator
CanPrint Communications Pty. Ltd.



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux