gopikumaran Posted March 26, 2014 Share Posted March 26, 2014 I would like check multiple columns for similar value and display them. Attached image will be helpful to understand. Quote Link to comment https://forums.phpfreaks.com/topic/287308-checking-duplication-in-mysql/ Share on other sites More sharing options...
DavidAM Posted March 26, 2014 Share Posted March 26, 2014 SELECT ... FROM ... WHERE (num1 = 123) OR (num2 = 123) OR (num3 = 123) Quote Link to comment https://forums.phpfreaks.com/topic/287308-checking-duplication-in-mysql/#findComment-1474025 Share on other sites More sharing options...
Barand Posted March 27, 2014 Share Posted March 27, 2014 The solution is to normalize your data and not use db tables like spreadsheets Quote Link to comment https://forums.phpfreaks.com/topic/287308-checking-duplication-in-mysql/#findComment-1474223 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.