coder9 Posted July 27, 2008 Share Posted July 27, 2008 I have this two syntax. Please tell me which is correct syntax. This one? $query = "SELECT * FROM jwinners WHERE prize IN('1', '2', '3', '4', '5')"; or this one? $query = "SELECT * FROM jwinners WHERE prize IN(1, 2, 3, 4, 5)"; prize is an integer column. Thank you. Link to comment https://forums.phpfreaks.com/topic/116825-which-select-is-correct/ Share on other sites More sharing options...
MFHJoe Posted July 27, 2008 Share Posted July 27, 2008 If it's an integer column the second one should be fine. Link to comment https://forums.phpfreaks.com/topic/116825-which-select-is-correct/#findComment-600738 Share on other sites More sharing options...
LemonInflux Posted July 27, 2008 Share Posted July 27, 2008 Have you tried them? That'll give you the answer really quickly Link to comment https://forums.phpfreaks.com/topic/116825-which-select-is-correct/#findComment-600747 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.