Liquid Fire Posted March 11, 2008 Share Posted March 11, 2008 when is the where if id is an int field is WHERE id = 123 better than WHERE id= '123' ? Quote Link to comment Share on other sites More sharing options...
trq Posted March 11, 2008 Share Posted March 11, 2008 What? Quote Link to comment Share on other sites More sharing options...
Liquid Fire Posted March 11, 2008 Author Share Posted March 11, 2008 I wish i could edit that, WOW, really really sorry about that. I bet you could never guess English it my first language. What i mean was: Lets say i have an id field that is type INT, would: WHERE id = 123 be better than: WHERE id= '123' ? Quote Link to comment Share on other sites More sharing options...
fenway Posted March 11, 2008 Share Posted March 11, 2008 MySQL will handle the type "conversion" if necessary -- the quotes prevent SQL injection attacks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.