MySQL Question

[eluser]Einspruch[/eluser]
This isn't a CI question, so forgive me!

I have a bunch of records in my database that have symbols like

Code:

™

in them. They are messing up my GROUP BY queries b/c it correctly views

Code:

Apple ™

as something different than

Code:

Apple

.

Is there an elegant way to get rid of them? Do I use MySQL's REPLACE function?

Thanks!

Robert

[eluser]stuffradio[/eluser]
Well... are you escaping your queries?