MySQL query

[KillerBean]

Kjipa query's:

$query = "SELECT aaa, bee FROM table WHERE aaa<=100 AND bee='viens' ASC";

 

tiek atlasiiti ieraxti kur bee ailee ir 'viens' a ja vajag atlasiit taadus kur bee ailee ir 'viens' vai 'divi'

 

$query = "SELECT aaa, bee FROM table WHERE aaa<=100 AND bee='viens' OR bee='divi' ASC";

 

un jautaajums ir par to OR lietoshanu vai vinja buus pareiza??! vai neiznaak, ka ir:

a) aaa<=100 && bee='viens'

b) bee='divi'

[Delfins]

Lieto iekavas:

 

A AND (B OR C)

[john.brown]

$query = "SELECT aaa, bee FROM table WHERE aaa<=100 AND bee IN('viens','divi') ASC";

Edited May 2, 2006 by john.brown

[KillerBean]

tnx, nezinaaju tikai to knifu vai queryaa to arii var lietot ;)

[Robis]

tā ir baigā fiška jeb zivs :)