# is using '' around number bad?

**URL:** <https://forums.percona.com/t/is-using-around-number-bad/115>\
**Category:** Other MySQL® Questions\
**Created:** [November 7, 2006, 10:49am UTC](https://forums.percona.com/t/is-using-around-number-bad/115 "2006-11-07T10:49:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![masterzen](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/masterzen/32/746_2.png) [@masterzen](https://forums.percona.com/u/masterzen)\
**Post date:** [November 7, 2006, 10:49am UTC](https://forums.percona.com/t/is-using-around-number-bad/115/1 "2006-11-07T10:49:29Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![inner](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/inner/32/16878_2.png) [@inner](https://forums.percona.com/u/inner)\
**Post date:** [November 7, 2006, 11:03am UTC](https://forums.percona.com/t/is-using-around-number-bad/115/2 "2006-11-07T11:03:08Z")

</div>

Hi,

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

Regards,  
Aurimas

---

<div class="post-metadata">

**Author:** ![masterzen](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/masterzen/32/746_2.png) [@masterzen](https://forums.percona.com/u/masterzen)\
**Post date:** [November 7, 2006, 11:28am UTC](https://forums.percona.com/t/is-using-around-number-bad/115/3 "2006-11-07T11:28:32Z")

</div>

| [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](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).