On Tuesday 05 February 2002 13:03, Matthias Hoffmann wrote: > dear all. > > I have a problem using mysql(occured at using phpMyAdmin): > i send the query: > DELETE FROM test WHERE user = "test" AND timestamp = "2002-02-05 > 21:42:53" AND var1="1000.1" LIMIT 1 > and 0 effect. > but when var1 has a (INT) value there's no problem: > DELETE FROM test WHERE user = "test" AND timestamp = "2002-02-05 > 21:42:53" AND var1="1000" LIMIT 1 > might there be a problem using such values? > has this error already occurded? I just joined this list....
There was just a thread on this topic. See the archives for the thread with the title "Problem with where clause" on the 1st of February. At the bottom of each e-mail on the list is a set of useful URLs to things like the archives. Best, Kyle --------------------------------------------------------------------- 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