is using '' around number bad?

MySQL & MariaDB Other MySQL® Questions
1

Hi,

I remind reading somewhere (was it on mysqlperformanceblog or in one of Peter’s presentation) that doing:

select * from mytable where param=‘12334’
instead of
select * from mytable where param=12334

was bad performancewise.

Can someone confirm this and explain why, please?

Thanks,

2

Hi,

i think this is pretty self-explanatory: http://www.mysqlperformanceblog.com/2006/09/08/why-index-cou ld-refuse-to-work/

Regards,
Aurimas

3
[B]inner wrote on Tue, 07 November 2006 11:33[/B]
Hi,

i think this is pretty self-explanatory: http://www.mysqlperformanceblog.com/2006/09/08/why-index-cou ld-refuse-to-work/

Thank you, I should have searched it myself.

Actually I was thinking it the other way (ie integer field and number as string in request).
It seems it is harmless in this case (although it is misleading).