· 7 years ago · Feb 13, 2019, 05:36 AM
1CREATE TABLE IF NOT EXISTS `default_item` (
2 `id` bigint(20) NOT NULL AUTO_INCREMENT,
3 `States` varchar(200) NOT NULL DEFAULT '""'
4 PRIMARY KEY (`id`)
5) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=637 ;
6
7INSERT INTO `default_Item` (`id` `States`) VALUES
8(636, '''AR'',''CA''');
9
10SELECT `States`
11FROM `default_item`
12WHERE `id`=636
13
14'AR','CA'
15
16SELECT group_concat( `state` )
17FROM `state`
18WHERE `state_abbr`
19IN (
20'AR', 'CA'
21)
22
23Arkansas,California
24
25SELECT group_concat( `state` )
26FROM `state`
27WHERE `state_abbr`
28IN (
29SELECT `States`
30FROM `default_item`
31WHERE `id`=636
32)
33
34SELECT group_concat( `state` )
35FROM `state`
36WHERE `state_abbr`
37IN (
38SELECT `States` FROM `default_item` WHERE `id`='636')
39
40SELECT group_concat( `state` )
41FROM `state`
42WHERE `state_abbr`
43IN (
44 "AR, CA"
45)