[RESOLVED] MySQL insert select statement

[spiritssight]

Hi,

I am wondering could I do this better then the below way?

both table are the same exact table setup and fields etc.

$query_is = "
INSERT INTO irs_query ( EIN, PNO, ICN, Street_Address, City, State, Postal_Code, GEN, Subsection_Code, Affiliation_Code, Classification_Code, Ruling_Date, Deductibility_Code, Foundation_Code, Activity_Code, Organization_Code, UL_Code, AFED, Tax_Period, Asset_Code, Income_Code, FR_Code, Blanks, Accounting_Period, Asset_Amount, Income_Amount, IAN_NS, F_990_RA, RAN_NS, NTEE_Code, SN_SNL ) 
SELECT EIN, PNO, ICN, Street_Address, City, State, Postal_Code, GEN, Subsection_Code, Affiliation_Code, Classification_Code, Ruling_Date, Deductibility_Code, Foundation_Code, Activity_Code, Organization_Code, UL_Code, AFED, Tax_Period, Asset_Code, Income_Code, FR_Code, Blanks, Accounting_Period, Asset_Amount, Income_Amount, IAN_NS, F_990_RA, RAN_NS, NTEE_Code, SN_SNL 
FROM irs_rawdata 
WHERE PNO LIKE '%blind%'";

Sincerely,
Christopher

[nemonoman]

If same, then:
INSERT INTO irs_query SELECT * FROM irs_rawdata
WHERE PNO LIKE '%blind%'";

[spiritssight]

Thank :-)
Christopher