MYSQL SELECT unexpected result

Question

Test table in the database looks like

id - int
title - varchar

+---+-------+
| id| title |
+---+-------+
|1  | name  |
+---+-------+

I run the query SELECT * FROM `Test` WHERE id="1abc"

Then it gives the output as

+---+-------+
|1  | name  |
+---+-------+

That's becouse id is integer, so, "1abc" will be convert to 1 — Roy Bogado
– Roy Bogado, Commented Aug 20, 2019 at 9:04

Roy Bogado · Accepted Answer · 2019-08-20 09:23:38Z

2

The Type Declared in ID is an Integer.

when you pass in a string beginning with a number, it would assume you are tyring to input a number value. Thus converting the value to an integer (the first letter in your string)

the warning message would appear as something like

Truncated incorrect DOUBLE value: "1abc"

Type Conversion Documentation

edited Aug 20, 2019 at 9:23

Roy Bogado

4,4721 gold badge18 silver badges36 bronze badges

answered Aug 20, 2019 at 9:08

Ryan Tan

3592 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ryan Tan Over a year ago

Also to add, if you run select convert('13deee2rf' , unsigned int); it will return you 13. hopefully this is clear

Collectives™ on Stack Overflow

MYSQL SELECT unexpected result

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related