First time here, sorry if this is too much of a novice question to get
answered...

I just sent the command:

DELETE FROM users WHERE user_num+"AL011-33";

by accident (I meant to use an "=" not the "+").  It killed 81 rows.  I
restored the data, but I couldn't find anything in the docs about what that
command actually did.

After restoring the data, I ran the command again (substituting SELECT for
DELETE) and it looks like it gives me all the users that have user_num that
start with a number rather than a letter.  I got the same results
regardless of whether I sent the command with a "-" or a "+".  What gives?



---------------------------------------------------------------------
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

Reply via email to