database, or you'll have endless problems <G>.
contains both if you want.
intent. You could consider stemming both at index and search time.
than you might think at first.
easily and not have to deal with wildcard complexity.
> I read the users data such as First Name, Last Name, Email and so on.
> I hava a field by column, such as: firstName="Frederich" lastName="Brown"
> What is the best way to do it?
> to "Fred" "Brown" and I search those tokens in every field.
> As "Brown" was indexed, the user's registry is found.
> But if the user enters "Fred", no user is found.
> Why is that? I thought it would return the user "Frederich Brown" either.