underscore(_) is considered a white space in search?

First time here? Check out the FAQ!

When we are searching with words that include an underscore (on a postgresql backend), it looks like the underscore is considered like a space and searches 2 words instead.

For example, putting long_word in the search box displays questions that have long AND word but does not specifically search for long_word.

Is it possible to change this behavior?

875

Benoit

asked 13 years ago

Comments

see more comments

1 Answer

Sort by

oldest

newest

most voted

Benoit, it is all done on the level of the database. Postgres itself tokenizes the query string, possibly it splits the words by the underscores as well. I gave only a very brief look into the docs and could not find anything quickly, but I will continue tomorrow.