Use double percent sign like so: %%special-purpose%%
.
Or you could also use a placeholder, i.e. LIKE %s
and then set the 6th parameter for $wpdb->prepare()
to %special-purpose%
, i.e.
$wpdb->prepare( "your SQL query", $earth_radius, $lat, $lng, $lat, '%special-purpose%' )