MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: search comma separated db column
Posted by: Peter Brawley
Date: April 24, 2008 09:47PM

Jon,

Storing a comma-separated list of numbers in a column violates a basic rule of database design, the atomicity rule (one cell, one value). You need to redesign.

PB
http://www.artfulsoftware.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
search comma separated db column
Jon Hollis
April 24, 2008 03:33PM
Re: search comma separated db column
Jon Hollis
April 24, 2008 03:44PM
Re: search comma separated db column
hhh3h asdf
April 24, 2008 05:03PM
Re: search comma separated db column
Peter Brawley
April 24, 2008 09:47PM
Re: search comma separated db column
Jesper Öhnstedt
April 25, 2008 04:15AM
Re: search comma separated db column
Peter Brawley
April 25, 2008 11:01AM
Re: search comma separated db column
Jesper Öhnstedt
April 25, 2008 12:34PM
Re: search comma separated db column
Peter Brawley
April 25, 2008 01:37PM
Re: search comma separated db column
Jesper Öhnstedt
April 25, 2008 01:48PM
Re: search comma separated db column
Peter Brawley
April 25, 2008 02:55PM
Re: search comma separated db column
Jesper Öhnstedt
April 25, 2008 03:16PM
Re: search comma separated db column
Peter Brawley
April 25, 2008 03:26PM
Re: search comma separated db column
Jesper Öhnstedt
April 25, 2008 03:46PM
Re: search comma separated db column
hhh3h asdf
April 28, 2008 11:41AM
Re: search comma separated db column
laptop alias
April 28, 2008 12:05PM
Re: search comma separated db column
Dave Clark
March 31, 2009 08:56PM
Re: search comma separated db column
Rick James
March 31, 2009 11:36PM
Re: search comma separated db column
Jesper Öhnstedt
April 29, 2008 01:32AM
Re: search comma separated db column
Dave Clark
March 31, 2009 08:55PM
Re: search comma separated db column
Brian Papantonio
April 28, 2008 08:08PM
Re: search comma separated db column
Peter Brawley
April 28, 2008 08:17PM
Re: search comma separated db column
Jesper Öhnstedt
April 29, 2008 12:53AM
Re: search comma separated db column
hhh3h asdf
April 30, 2008 12:36PM
Re: search comma separated db column
Shawn Grigson
March 31, 2009 08:36PM
Re: search comma separated db column
Guelphdad Lake
March 31, 2009 08:42PM
Re: search comma separated db column
Guelphdad Lake
April 01, 2009 08:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.