where clause in mysql to include all and exclude a string

Question

Select * from table where col1 <> 'R'

col1 has various values and also has NULL how to write the where statement which includes all also the NULL value except the 'R' string

Yup - so you chose `null` (first part) **or** everything but 'R' (second part) — Eugen Rieck, Mar 07 '20 at 13:03
What is wring with your query could you provide example data where it doenn#t work — nbk, Mar 07 '20 at 13:04

Tushar · Answer 1 · 2020-03-07T13:06:54.933

1

Select * from table where col1 <> 'R' OR col1 IS NULL

For get null value use IS NULL, if you also expect value of 'R', add col1 <> 'R'.

edited Mar 07 '20 at 13:06

answered Mar 07 '20 at 13:01

Tushar

1 Answers1