A simple SELECT problem

qqxbxb

SELECT *
FROM t1
WHERE
(Col004 like '% keyword 1%') OR
(Col004 like '% keyword 2%') OR
 and
(Col003 like 'Keyword 3%') OR
(Col003 like'Keyword 4 ') OR
      
I want to find the record in T1 where Col004 contains keyword 1 or keyword 2 and Col003 contains keyword 3 or keyword 4. For example, a record Col004 containing the keyword 1 and Col003 containing the keyword 4 are eligible, but the above statement does not seem to be implemented? ? How to write the correct one?

wgfxman

SELECT *
FROM t1
WHERE
((Col004 like '% keyword 1%') OR
(Col004 like '% Keyword 2%'))
 and
((Col003 like 'Keyword 3%') OR
(Col003 like 'Keyword 4'))

wgfxman

SELECT *
FROM t1
WHERE
((Col004 like '% keyword 1%') OR
(Col004 like '% Keyword 2%'))
 and
((Col003 like 'Keyword 3%') OR
(Col003 like 'Keyword 4%'))

% Is missing

qqxbxb

It ’s not this% problem, I missed it here, I think it ’s the problem of the statement itself? ?

qqxbxb

The problem with this sentence:
(Col004 like '% Keyword 2%'))
 and
((Col003 like 'Keyword 3%')
and is reflected between these two, the other has no effect of AND

cosine0

First put SELECT *
FROM t1
WHERE
(Col004 like '% keyword 1%') OR
(Col004 like '% keyword 2%') OR made into a view, and then through SELECT *
FROM view WHERE (Col003 like 'Keyword 3%') OR
(Col003 like 'Keyword 4')

pguppgdn

SELECT *
FROM t1
WHERE
(
(Col004 like '% keyword 1%') OR
(Col004 like '% Keyword 2%') OR
)
and
(
(Col003 like 'Keyword 3%') OR
(Col003 like 'Keyword 4') OR
)

fanfan1980

--try

SELECT *
FROM t1
WHERE
((Col004 like '% Keyword 1%') OR (Col004 like '% Keyword 2%'))
and
((Col003 like 'Keyword 3%') OR (Col003 like '% Keyword 4%'))