On 25-Jun-2003 Brent Genereux wrote:
> I have odd characters in my database that appeared after updating from a
<snip>
>
> I've copied the character into a text editor that can display the
> hexidecimal value of the characters. The square character is different
> than
> a space, but for some reason when executing the SQL query it thinks they
> are
> the same. Any suggestions would be helpful.
>
SELECT * FROM tablename WHERE fieldname LIKE CONCAT('%', CHAR(0x??), '%');
UPDATE tablename SET fieldname=REPLACE(fieldname, CHAR(0x??), ' ');
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
