search for: existingbob

...er word searches. I am going to use an example to explain my problem. Here it is: There is a table called users and it has login, first_name, last_name columns. There are three rows inside it. login first_name last_name bob bob henry longbob nil nil existingbob nil nil Now I am expecting to get all three rows as the search result and my search query is: "bob OR *bob* OR bob* OR *bob" However, I am only getting longbob and existingbob rows, not the user bob. I have tried many other queries and still no luck. At first I thought that...