Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re^4: Storing multiple value field in a MySQL database

by mba777 (Novice)
on Nov 25, 2013 at 20:02 UTC ( #1064284=note: print w/replies, xml ) Need Help??

in reply to Re^3: Storing multiple value field in a MySQL database
in thread Storing multiple value field in a MySQL database

Hi, i understand davido's solution, and i know that it is the better solution, but i exactly mean something like that:

Table1: userid email age memberof john 45 admins,wizzards jerry 22 newbies,trainees,newhires

And i do not need an efficient way to search for all newhires. The filed memberof should only be additional information.

So can you only show me perhaps an code example how to store multiple value files in one single mysql column. Thanks ;)

Replies are listed 'Best First'.
Re^5: Storing multiple value field in a MySQL database
by GrandFather (Sage) on Nov 25, 2013 at 20:51 UTC

    My hesitation in showing code for simply concatenating the values together with join is that that is such a standard and trivial thing to do that I couldn't believe that that was the solution you were looking for. roboticus's reply++ tells you how to do that and also fills in details for using a table join to use davido's suggested technique.

    If it really is the case that you were struggling with concatenating a list of strings I strongly advise you show us more of your code and ask for comment in a new Seekers of Perl Wisdom node as there are very likely other areas where your code could use some constructive criticism.

    True laziness is hard work

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1064284]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (5)
As of 2018-05-24 19:49 GMT
Find Nodes?
    Voting Booth?