Re: partial match of field in table for SELECT statement
thanks all for the reply
i'm not sure the Id column is not what I need/want, that's a numeric id from 1 -> 20k
here's the results from show create: (this is longer cause the one i posted was just a truncated version)
*************************** 1. row ***************************
Table: TCGA-PCa_normal
Create Table: CREATE TABLE `TCGA-PCa_normal` (
`Id` varchar(100) DEFAULT NULL,
`GeneSymbol` varchar(100) DEFAULT NULL,
`EntrezID` varchar(100) DEFAULT NULL,
`TCGA-G9-6384-11A-01R-1858-07` varchar(100) DEFAULT NULL,
`TCGA-CH-5767-11B-01R-1789-07` varchar(100) DEFAULT NULL,
`TCGA-G9-6348-11A-01R-1789-07` varchar(100) DEFAULT NULL,
`TCGA-G9-6356-11A-01R-1789-07` varchar(100) DEFAULT NULL,
`TCGA-G9-6365-11A-01R-1789-07` varchar(100) DEFAULT NULL,
`TCGA-G9-6496-11A-01R-1789-07` varchar(100) DEFAULT NULL,
`TCGA-CH-5768-11A-01R-1580-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7115-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7314-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7315-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7317-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7321-11A-01R-2263-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7327-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7328-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7330-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7781-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7782-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7783-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7784-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7785-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7786-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7789-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7792-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7793-11A-01R-2263-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7794-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7797-11A-01R-2263-07` varchar(100) DEFAULT NULL,
`TCGA-HC-7211-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-HC-7737-11A-02R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-HC-7738-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-HC-7740-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-HC-7742-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-HC-7745-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-HC-7747-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-HC-7752-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-HC-7819-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-HC-8258-11A-01R-2263-07` varchar(100) DEFAULT NULL,
`TCGA-HC-8259-11A-01R-2263-07` varchar(100) DEFAULT NULL,
`TCGA-HC-8260-11A-01R-2263-07` varchar(100) DEFAULT NULL,
`TCGA-HC-8262-11A-01R-2263-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7125-11A-01R-1965-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7123-11A-01R-1965-07` varchar(100) DEFAULT NULL,
`TCGA-G9-6333-11A-01R-1965-07` varchar(100) DEFAULT NULL,
`TCGA-CH-5761-11A-01R-1580-07` varchar(100) DEFAULT NULL,
`TCGA-G9-6342-11A-02R-1965-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-7331-11A-01R-2118-07` varchar(100) DEFAULT NULL,
`TCGA-CH-5769-11A-01R-1580-07` varchar(100) DEFAULT NULL,
`TCGA-G9-6362-11A-01R-1789-07` varchar(100) DEFAULT NULL,
`TCGA-G9-6363-11A-01R-1789-07` varchar(100) DEFAULT NULL,
`TCGA-G9-6499-11A-02R-1965-07` varchar(100) DEFAULT NULL,
`TCGA-G9-6351-11A-01R-1965-07` varchar(100) DEFAULT NULL,
`TCGA-EJ-A8FO-11A-11R-A36G-07` varchar(100) DEFAULT NULL,
`TCGA-J4-A83J-11A-11R-A36G-07` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1