MySQL MATCH AGAINST and $wpdb->prepare()
Can they work together? I cant find o开发者_Python百科ne example anywhere.
I have tested it with:
$sql = $wpdb->prepare('SELECT * FROM wp_posts
WHERE MATCH(post_content) AGAINST ("test")');
$results = $wpdb->get_results($sql);
And it works fine. But of course, I had to create a FULLTEXT index on the post_content
field first, as Wordpress doesn't include this type of index (v3.1).
精彩评论