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.
geting substrings and showing as a new field.
3 posts
• Page 1 of 1
geting substrings and showing as a new field.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. Best Regards
U.
Re: geting substrings and showing as a new field.
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
Thanks!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 Best Regards
U.
3 posts
• Page 1 of 1
Who is onlineUsers browsing this forum: No registered users and 24 guests |