geting substrings and showing as a new field.

Archived from the Xataface Users forum.

ulisespm — Wed Jun 24, 2009 9:14 am

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 — Wed Jun 24, 2009 4:47 pm

ulisespm wrote: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 — Thu Jun 25, 2009 9:14 am

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