Is there any kind of UPDATE query limitation that would not allow me to make the following update? <!-- Update SQL: UPDATE wdCaseThread SET body='Why doesn\'t this work? http://www.mysite.com'
Actual data after update: Why doesn't this work? [http://www.mysite.com] --> Basically my update is updating to the same text, only without the '[' and ']' from around the url. Only mysql is not updating the record. If I try updating to something else (like add an "asdf" in between "Why doesn't this work?" and "http://www.mysite.com"; while removing the "[" and "]" it works... I tried messing around, and noticed that this happens with \' character as well as quotes, a regular alpha character seems to work properly... Any ideas? ------------------------------------------------------------------------------------ When I run: "Check table wdCaseThread" this is what I receive mysql> check table wdCaseThread; +--------------------------------+-------+----------+----------------------------+ | Table | Op | Msg_type | Msg_text | +--------------------------------+-------+----------+----------------------------+ | wirelessdeveloper.wdCaseThread | check | warning | Table is marked as crashed | | wirelessdeveloper.wdCaseThread | check | status | OK | +--------------------------------+-------+----------+----------------------------+ 2 rows in set (0.01 sec) What does table is marked as crashed mean? If I run check table wdCaseThread once more it shows up as OK. ????????? ------------------------------------------------------------------------- Here is the structure of my table: wdCaseThread Table Structure mysql> describe wdCaseThread; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | threadID | int(10) unsigned | | PRI | NULL | auto_increment | | historyID | int(10) unsigned | YES | | NULL | | | body | text | YES | MUL | NULL | | | htmlBody | text | YES | | NULL | | +-----------+------------------+------+-----+---------+----------------+ 4 rows in set (0.22 sec) I also Have a fulltext index on body -- _____________________ Jason Kushmaul, Software Engineer WirelessDeveloper.com Suite 200 2875 Northwind Drive East Lansing, MI 48823 [EMAIL PROTECTED] (517)337-2701 ext. 205 Become a Member Today!! http://www.WirelessDeveloper.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
