MySQL automatically cast/convert a string to a number?
The answers to your first three questions are: yes, yes, and no. When the string ‘text’ is converted to a number, it becomes the value 0. The documentation that describes type conversion is here. For your query: SELECT table.* FROM table WHERE id=’text’; The rule is captured by this excerpt from the documentation: In all … Read more