I am trying to perform a search on my database. When a user types in text and submits, I search the database for anything that matches the text, and I am also using the SPLIT function to break the text apart in order to search for just some of the text and not all. Anyway, that is working fine, however, I want to rank my results. I want results that contain the entire phrase to be returned first, followed by the other results that only contain part of the phrase. Is there a way to do that? I was thinking of doing something like ORDER BY number of characters...since the entire phrase will always be longer than just pieces of it. Does this make sense? How should I approach this?