geting substrings and showing as a new field.

[ulisespm]

Hi Steve, Hi All:

I need to "make" a field based on some substrings from another fields (name, lastname).

I've tried to perform it in MyPhpAdmin but I couldn't.

Any idea about how to perform this task?

Thanks in advance for your help.

[cragthehack]

Hi Steve, Hi All:

I need to "make" a field based on some substrings from another fields (name, lastname).

I've tried to perform it in MyPhpAdmin but I couldn't.

Any idea about how to perform this task?

Thanks in advance for your help.

You can do it in the sql. Take a look at the concat function in mysql. here's a link to all string fuctions for mysql: http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html

[ulisespm]

Thanks for your reply.

I've looked for substring and concat mysql functions. Unfortunately I don't know how to make that a field gets those functions and "build" the new content for each user.

I mean, in my PhpMyAdmin I have inserted the "query" in the SQL Editor and it only allows me to perform this action (substring, concat) with the content of a single register, not with the "field" itself...

Please help me

Thanks in advance