I'm working on the search functionality of a website and I want the user to be able to search for keywords. Everything works, except when the user enters "90s" it changes from "b.Name LIKE '%90s%'" to "b.Name LIKE 's%'". why is it doing that? And what can I do to force it to search for the entire query?
My guess would be that there is URL decoding somewhere along the way. If that is the case, you have to URL encode the string. Since %90 is an unassigned character, it wouldn't decode to anything. You can try searching for '%2590' and see if that goes through as %90 to test. If that is the case, you would have to encode the string before it gets decoded.