• Resolved OllieJones

    (@olliejones)


    While working on the SQLite Database Integration plugin I stumbled across a small problem in your code: You don’t always escape _ characters you intend to be literal rather than wildcard in LIKE clauses in your SQL. For example, class_clean_transient.php lines 83-97 contains constructs such as option_name LIKE '_site_transient_%'. I am pretty sure you want option_name LIKE '\_site\_transient\_%' instead in this kind of situation. You may even want to use $wpdb->esc_like() for this.

    Very useful plugin, by the way. Thank you.

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘LIKE wildcard escaping problem’ is closed to new replies.