LIKE wildcard escaping problem
-
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 asoption_name LIKE '_site_transient_%'
. I am pretty sure you wantoption_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.