Hi,
How can I check all duplicated rows out from a large table?
The values are not keys so they may have more than one occurrence.
Thanks for your help.
Regards, CHAN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
t;
> Can you send complete test for your problem?
>
> "YW CHAN (Cai Lun e-Business)" <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I find there seems problem with this select statement when there is a
> > special
> > character inside the table
Hi,
I find there seems problem with this select statement when there is a special
character inside the table. i.e.
select concat(field_1, ',', field_2) as name where ...
field_2 actually is something like 'George, Banson' ( with a comma in between )
i guess this , destroy the SQL syntax.
I
