WordPress的SQL帖子标题搜索

Question

我正在建立一个大的自定义搜索作为目录的WordPress的网站。部分搜索使用SQL来轮询多个元值，另一部分是标题。在查询标题时，我看不到一个简单的SQL LIKE。下面是我的代码：你LIKE

SELECT * FROM wp_posts WHERE post_type = 'business' AND post_status = 'publish' AND post_title LIKE 'Butler' ORDER BY post_title ASC 

Answer 1

使用通配符：

SELECT * FROM wp_posts 
WHERE post_type = 'business' 
AND post_status = 'publish' 
AND post_title LIKE '%Butler%' 
ORDER BY post_title ASC