See Bulletpusher's answer 
 
 
   They are totally different cartidges.
The 38 Special is extremely common- and it's chambered almost exclusively in revolvers.
   38 Super ammo is still made, although it's far less common- and it's chambered almost exclusively in semi autos.