Mysql Update

2003-02-26 Thread Daniele Lo Re
Hi everybody I sent a couple of mail recently, asking some help for some strange behaviour with select and updates. I hope many of you have read it...the problem was that making a SELECT something FROM table WHERE 'Where_Clause' gave some results, >0. the query: UPDATE table SET something WHE

Strange Updates

2003-02-11 Thread Daniele Lo Re
Hi everybody I got weird behaviour from Mysql while doing some updates. Before doing the update I did a count, like this: select count(*) from Yellow WHERE MATCH(street_add) AGAINST('+GUIDO +MIGLIOLI' IN BOOLEAN MODE) AND street_short = ''; and the result was 50 rows in set. But when I ran t

SELECT & UPDATE

2003-01-28 Thread Daniele Lo Re
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 wa