Hi @jamiemccardle, @RahulPa - There are two things to consider: 1) We do not index special characters 2) Auto-Suggest and SERP search are slightly different. Every special character is considered as a whitespace and characters preceding and succeeding the special character are considered as two separate words.
Example: For Auto-suggest, in your query, the search will happen for words "awrrpt" and "sql...". So all the posts that have "awrrpt" and "sql" and words that begin with "sql" will be showcased. In your case, there is 1 result that you got. On SERP page, the search will happen for "awrrpt" AND/OR "sql". Here, the search results fetched would be more and will be ranked basis the frequency of the words in the post. Thus your relevant result went beyond the first page.
Thanks
... View more