Do you have a question? Post it now! No Registration Necessary. Now with pictures!
August 26, 2006, 5:06 pm
rate this thread
Re: Query Help
When working with a Relational Data Base Management System like
MySql you should use a different approach.
Create a second table where each row consists of two columns;
the row id (from the 1st table) and one of the categories the
row falls in. For each category a row is in the original table
falls in there will be one row in the new table.
If all you need is the identify of the rows a query against the
new table will provide the answer. If you need the contents of
the row in the original table a join will provide the answer.
If you are not familiar with RDBMS this might seem inefficient
and wasteful -- it isn't! This is because RDBMS are designed to
handle sets of data, but are not very good at splitting out and
working with parts of a "field".
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum