How to prepare a %LIKE% SQL statement in WordPress?

Web Development
, ,
1

I am building a custom query using the WordPress $wpdb class. I want to prepare a LIKE %text% statement using $wpdb->prepare().

"SELECT * FROM {$wpdb->prefix}my_table WHERE column LIKE '%text%'";

How do I sanitize and prepare the statement with the WordPress database class?

$wpdb->prepare("SELECT * FROM {$wpdb->prefix}my_table WHERE column LIKE %%s%", $text);
2

You can try the example below. It should work.

$wpdb->prepare(
    "SELECT * FROM {$wpdb->prefix}my_table WHERE column LIKE %s", 
    "%" . $text . "%"
);