How should a mysql query to the wordpress database look like for a certain selection of records?

Question

MySQL

Help with writing a query to the database. The point is this. It is necessary to select all posts that contain a certain word in post_title and do not have comments on these posts.
If anyone answers, thanks in advance!

Answer 1

Select * from table where post_title = "key" and comment_fld is null;