Did the update work? I would expect it did and is just reported that you have not added or taken away any rows. Simon
-----Original Message----- From: Daniele Lo Re [mailto:[EMAIL PROTECTED]] Sent: 28 January 2003 14:24 To: [EMAIL PROTECTED] Subject: SELECT & UPDATE Hi everybody. I got a really weird behaviour from Mysql, while doing some select and update queries. I made a select, something like: SELECT Something FROM .... WHERE.... and the result was not empty. But when I tried to make an update: UPDATE......WHERE , with THE SAME WHERE clause, result was empty. I'm sure that it's not reguarding permissions, and rows were not updated yet, that is UPDATE returned: Matching rows = 0 Updated rows = 0. A MATCH() search was used in the queries. Does anybody have ideas. Thanks Daniele --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
