Помогите оптимизировать запрос

[shaelf]

Помогите оптимизировать запрос

Только не пугайтесь. Можно это как нить покороче сделать?
$PERFORMANCE SERIES=mysql_query("SELECT marca, opis, cena FROM paradigm WHERE seria='PERFORMANCE SERIES'");
$PERFORMANCE SERIES_select=mysql_fetch_assoc($PERFORMANCE SERIES);
$MONITOR SERIES=mysql_query("SELECT marca, opis, cena FROM jbl WHERE seria='MONITOR SERIES'");
$MONITOR SERIES_select=mysql_fetch_assoc($MONITOR SERIES);
$REFERENCE SERIES=mysql_query("SELECT marca, opis, cena FROM jbl WHERE seria='REFERENCE SERIES'");
$REFERENCE SERIES_select=mysql_fetch_assoc($REFERENCE SERIES);
$CENTRAL CHANNEL=mysql_query("SELECT marca, opis, cena FROM jbl WHERE seria='CENTRAL CHANNEL'");
$CENTRAL CHANNEL_select=mysql_fetch_assoc($CENTRAL CHANNEL);
$LEFT CENTRAL RIGHT=mysql_query("SELECT marca, opis, cena FROM jbl WHERE seria='LEFT CENTRAL RIGHT'");
$LEFT CENTRAL RIGHT_select=mysql_fetch_assoc($LEFT CENTRAL RIGHT);
$SURROUND=mysql_query("SELECT marca, opis, cena FROM jbl WHERE seria='SURROUND'");
$SURROUND_select=mysql_fetch_assoc($SURROUND);
$POWERED SUBWOOFERS=mysql_query("SELECT marca, opis, cena FROM jbl WHERE seria='POWERED SUBWOOFERS'");
$POWERED SUBWOOFERS_select=mysql_fetch_assoc($POWERED SUBWOOFERS);
$PASSIVE SUBWOOFERS=mysql_query("SELECT marca, opis, cena FROM jbl WHERE seria='PASSIVE SUBWOOFERS'");
$PASSIVE SUBWOOFERS_select=mysql_fetch_assoc($PASSIVE SUBWOOFERS);
$AMS=mysql_query("SELECT marca, opis, cena FROM jbl WHERE seria='AMS'");
$AMS_select=mysql_fetch_assoc($AMS);
$STYLUS=mysql_query("SELECT marca, opis, cena FROM jbl WHERE seria='STYLUS'");
$STYLUS_select=mysql_fetch_assoc($STYLUS);
$CS=mysql_query("SELECT marca, opis, cena FROM jbl WHERE seria='CS'");
$CS_select=mysql_fetch_assoc($CS);

 

[Profic]

1) where field in (список значений)
2) читать мануал по mysql

 

[shaelf]

Понят, пасиб, попробую.