WordPress php mysql LIKE query not working

February 16, 20231 Views

$db_item =  $wpdb->get_results($wpdb->prepare( "SELECT * FROM wp_wowhead_items WHERE name LIKE %s", "%". "Hello" . "%") );

This above one works… But the below one doesn’t work!

$text = "Hello";
$db_item =  $wpdb->get_results($wpdb->prepare( "SELECT * FROM wp_wowhead_items WHERE name LIKE %s", "%". $text . "%") );

Where am I missing the syntax? I tried almost every combination with quotes, slashes, escapes…

Post Views: 1

3 comments

Anonymous says:

February 16, 2023 at 1:13 am
Escape it with double %%

When using get_results() in WordPress, all % characters inside SQL string literals, including LIKE wildcards, must be double-% escaped as %%

$db_item = $wpdb->get_results($wpdb->prepare(
```
"SELECT * FROM wp_wowhead_items WHERE name LIKE '%%$text%%'"
```
));
Log in to Reply

Wrap it in quotes:

$db_item =  $wpdb->get_results($wpdb->prepare(
            "SELECT * FROM wp_wowhead_items WHERE name LIKE %s", "'%". $text . "%'"));

Try this:

$db_item =  $wpdb->get_results($wpdb->prepare(
    "SELECT * FROM wp_wowhead_items WHERE name LIKE %s", '%$text%'"
));