[WordPress] Escaping Strings For WordPress Database Queries

00-escaping-a-string.php

<?php
$query = 'SELECT value FROM wp_acme_table WHERE value LIKE "%' . mysqli_real_escape_string( $value ) . '%"';

01-escaping-a-string-with-a-value.php

<?php

$value = 'Fox Mulder says "I want to believe."';
$query = 'SELECT value FROM wp_acme_table WHERE value LIKE "%' . mysqli_real_escape_string( $value ) . '%"';

02-a-raw-query.php

<?php
'SELECT value FROM wp_acme_table WHERE value LIKE "%Fox Mulder says "I want to believe."%"';