OK, nevermind. I saw a couple other posts and realized I could change the query on lines 1442 and 1528.
I changed it from:
$results_sql = "SELECT id,field_id,field_input FROM " . $table . " WHERE field_input COLLATE UTF8_GENERAL_CI LIKE '" . $_POST['sds-search-data'] . "%' ORDER BY id ASC";
to
$results_sql = "SELECT id,field_id,field_input FROM " . $table . " WHERE field_input COLLATE UTF8_GENERAL_CI LIKE '%" . $_POST['sds-search-data'] . "%' ORDER BY id ASC";
The difference is a %.
[Moderator note: code fixed. Please wrap code in the backtick character or use the code button.]
-
This reply was modified 8 years ago by bdbrown.
