· 8 years ago · Mar 04, 2018, 07:46 PM
1--
2-- Table structure for table `comparebug`
3--
4
5CREATE TABLE IF NOT EXISTS `comparebug` (
6 `integer` int(11) NOT NULL AUTO_INCREMENT,
7 `string` varchar(255) NOT NULL,
8 PRIMARY KEY (`integer`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=322 ;
10
11--
12-- Dumping data for table `comparebug`
13--
14
15INSERT INTO `comparebug` (`integer`, `string`) VALUES
16(123, '123-dummy'),
17(321, '444-dummy');
18
19--
20-- Query
21--
22
23SELECT * FROM `comparebug`
24WHERE `integer` = `string`;
25
26--
27-- Result
28--
29
30+---------+-----------+
31| integer | string |
32+---------+-----------+
33| 123 | 123-dummy |
34+---------+-----------+
35
36
37--
38-- The fuck ?
39--