Corrected single-character match for SQL pattern, _, instead of ? used in a shell.

No solution, or clue; just thinking out loud ...

They'd like to insert an entry like this:

+-----+-----------+-----+
|rowid|    old    | new |
+-----+-----------+-----+
|  5  | D7*D-48*6 | EEE |
+-----+-----------+-----+
[download]

The expectation being that searching for D7RD or DD482 would return row #5.

... 😬oof, that is reverse of more ideal situation (search for %D7_D% against D7RD-4826).

As is, would have to search for a string character by character (as * could be anywhere), to iteratively reduce the result set: get row indices with D%; then search those for D7% of those row indices; then for D7R% of that result; and then for D7RD% of that result. (Or, work from larger string to smaller string.?)

Thinking of storing D7*D-48*6 as SQL pattern (D7_D-48_6) to search against if that could help any.

And I hate it.