StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSubquery does not work, but substituting subquery results does
text
Body
copied!<p>Okay, I am using the <code>states</code> table found <a href="http://kimbriggs.com/computers/computer-notes/mysql-notes/mysql-create-state-table.file" rel="nofollow">here</a></p> <p>...AND A TABLE <code>default_item</code> defined:</p> <pre><code>CREATE TABLE IF NOT EXISTS `default_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `States` varchar(200) NOT NULL DEFAULT '""' PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=637 ; INSERT INTO `default_Item` (`id` `States`) VALUES (636, '''AR'',''CA'''); </code></pre> <p>I have a field in a table that contains a list of State abbreviations, the field is "States", so if I select one of those fields as example:</p> <pre><code>SELECT `States` FROM `default_item` WHERE `id`=636 </code></pre> <p>This returns via PHPMyAdmin:</p> <pre><code>'AR','CA' </code></pre> <p>I want to be able to replace the state abbreviations with the state names from the table 'state' cited above. If I use:</p> <pre><code>SELECT group_concat( `state` ) FROM `state` WHERE `state_abbr` IN ( 'AR', 'CA' ) </code></pre> <p>It works! I get:</p> <pre><code>Arkansas,California </code></pre> <p>But if I use the subquery...</p> <pre><code>SELECT group_concat( `state` ) FROM `state` WHERE `state_abbr` IN ( SELECT `States` FROM `default_item` WHERE `id`=636 ) </code></pre> <p>...this returns NULL.</p> <p>Have been searching for some hint as to what I am doing wrong, but cannot seem to find the trick. Anyone have a solution?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload