I'm attempting to retrieve all rows that include two specific characters within a set of characters corresponding to the attributable column of data. However, the specified characters can't be included within the beginning or the end of that series of characters.
My attempt currently displays the specified characters but includes beginning and ending characters. However I only want to display those characters contained in between the sequence.
I tried this query:
SELECT table_id, table_number FROM TABLE WHERE table_number LIKE '%99%';