query speed and field types

[________]

Hi,
I have a test table with 35 000 rows. One of the fields is calles hehe (varchar). When I ran this query "SELECT FROM table WHERE hehe = 2, the query was slower then when i ran this query "SELECT FROM table WHERE hehe = '2'"

When I changed the field to int() it was faster not using '
Does anyone know why?

[mrhappiness]

2 is an integer
'2' is considered as string

if you compare a column of type varchar with an int mysql needs to do a type conversion for the compariosn to work

if you compare a column of type intwith an string mysql needs to do a type conversion for the compariosn to work

as type conversions cost time... i giuess you got it 🙂

[________]

But it is a quiet big difference.
0.05 - is all that time neede to convert the string, og does it convert it for each row?

[mrhappiness]

afair mysql converts the column for each and every row, so the bigger your table is the slower the query will be

[________]

Thanks!