MySQL Forums
Forum List  »  Newbie

WHERE syntax
Posted by: Wim Roffel
Date: September 24, 2019 04:14AM

To my surprise the following query:

SELECT * FROM products WHERE id_product='51-5-19199';

returned a product with id_product=51

I expected that only full match with the string would work. Can someone help me understand what part of the syntax I am missing? Does the dash have some special meaning?

Options: ReplyQuote

Written By
WHERE syntax
September 24, 2019 04:14AM
September 24, 2019 09:59AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.