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. 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) 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 Link to comment https://forums.phpfreaks.com/topic/287308-checking-duplication-in-mysql/#findComment-1474223 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.