Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
select COLUMN1 as VARIABLE1, COLUMN2+'-'+COLUMN3+'-'+COLUMN4 as VARIABLE2, LEFT(COLUMN2, 2) as VARIABLE3, RIGHT (COLUMN2, 4) as VARIABLE4, COLUMN2 as VARIABLE5, COLUMN3 as VARIABLE6, case when COLUMN2 like '%1%' then 'CASE1' when COLUMN2 like '%2%' then 'CASE2' when COLUMN2 like '%3%' then 'CASE3' end as VARIABLE7, from TABLE1.COLUMN1 where TABLE1.COLUMN2 like 'MATCH' and TABLE2.COLUMN3 = TABLE2.COLUMN4
$qry = "INSERT INTO table (one, two, three) VALUES('$one','$two','$three')"; $result = @mysql_query($qry); $qry2 = "INSERT INTO table2 (two) VALUES('$two')"; $result = @mysql_query($qry2);
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.