🔒 Closed Question re: sql two "or"

[Racer_X]

Hi po

Ask ko lang po paano po hihiwalay yung or or sa sql?
Dalawa or po kasi mag kakadikit

Col1=' ' or is null or Col2=' ' or is null

Salamat po

 

[k4rm4]

(Col1='' || is null) || (Col2= || is null)
mali po ang syntax pero ganyan po ba yung logic?

 

[Racer_X]

(Col1='' || is null) || (Col2= || is null)
mali po ang syntax pero ganyan po ba yung logic?

Hmm di ku po alam..pero ta try ku yan ||

Yung or gagawin ku ||

 

[k4rm4]

Hmm di ku po alam..pero ta try ku yan ||

Yung or gagawin ku ||

OR po ginagamit sa sql

 

[Racer_X]

(Col1='' || is null) || (Col2= || is null)
mali po ang syntax pero ganyan po ba yung logic?

Query po tawag sa syntax po

OR po ginagamit sa sql

Lalagayn ku po si guru ng bracket. Cge po. Salaamat po

 

[DarkAkira]

tama na po ata yung code ninyo , need lang double quote?

 

[Racer_X]

OR po ginagamit sa sql

Ayaw po kasi nito gumana

SELECT * from tablename where (col1=' ' or is null) or (col2=' ' or is null)

Eto pp yung ginawa ku pero ayaw po gumana



SELECT * from tablename where (col1=' ' or is null) or (col2=' ' or is null)

 

[DarkAkira]

Ayaw po kasi nito gumana

SELECT * from tablename where (col1=' ' or is null) or (col2=' ' or is null)

Eto pp yung ginawa ku pero ayaw po gumana



SELECT * from tablename where (col1=' ' or is null) or (col2=' ' or is null)

remove mo po yung 'is'


SELECT * from tablename where col1=' ' or null or col2=' ' or null

 

[k4rm4]

Eto po, gumana yung ganito

 

[Spike Spiegel]

WHERE ((Col1=' ' OR IS NULL) OR (Col2=' ' OR IS NULL))

pa try kung working?

 

[vhin le]

WHERE (Col1=' ' OR Col1 IS NULL) OR (Col2=' ' OR Col2 IS NULL)