SQL statement Condition query problem

There are four key words: keyword 1, keyword 2, keyword 3, keyword 4,
I'm going to go out. A field in the database contains "keyword 1" or "Keyword 2" or "Keyword 3" but does not contain "keyword 4" data, how to write SQL statement?

Reply to discussion (solution)

SELECT * FROM table where (a field like '% keyword 1% ' or a field like '% keyword 2% ' or a field like '% keyword 3% ') and a field not like '% keyword 4% '

Upstairs positive solution

Second floor positive solution. It's a great writing.

So much or you can think of regular.

SELECT * from tbl_name WHERE field REGEXP ' keywords 1| keywords 2| keyword 3 ' and  field not REGEXP ' keyword 4 '

SELECT * from tbl_name WHERE field REGEXP ' keywords 1| keywords 2| keyword 3 ' and  field not REGEXP ' keyword 4 '

Study the

SELECT * from tbl_name WHERE field REGEXP ' keywords 1| keywords 2| keyword 3 ' and  field not REGEXP ' keyword 4 '

This method will search for duplicate data

SELECT * FROM table where (a field like '% keyword 1% ' or a field like '% keyword 2% ' or a field like '% keyword 3% ') and a field not like '% keyword 4% '

This method will search for duplicate data

Contains "Keyword 1" or "Keyword 2" or "Keyword 3"

That's what your needs are, repetition is normal.

Contains "Keyword 1" or "Keyword 2" or "Keyword 3"

That's what your needs are, repetition is normal.

Contains "Keyword 1" or "Keyword 2" or "Keyword 3"

That's what your needs are, repetition is normal.

I don't seem to have duplicate data, what should I do?
Thanks for pointing.

Try distinct.

