[TYPO3-english] DB Select

[Bernhard Kraft]

Jan Bednarik schrieb:
> Hi,
> 
>> Example Table 2
>> uid;name;category
>> 1;name1;1,2
>> 2;name2;2
>> 3;name3;1,2,3
> 
> this is wrong databse design, that violates even the first normal form
> (see http://en.wikipedia.org/wiki/Database_normalization)
> 

Yes. Roberto, you should really think about redesigning your database.
Using comma-separated values for relations is not really the way to go.
You can use comma separated values, if you do not need to join those
values directly by an SQL query - which is exactly what you asked.

so better go on and read the article about database-normalization or buy
a good book about data structures and database design.


greets,
Bernhard