Using Regex in SOLR Query

I have a data set of street names and numbers which I need to search.

eg. 12 HILL STREET
    12A HILL STREET
    12B HILL STREET
    123 HILL STREET
    12 HILARY STREET

If I search as follows q=(street_name:12\ HILL*), I get

12 HILL STREET

I want to obtain the following results:

12 HILL STREET
12A HILL STREET
12B HILL STREET

Is there a way to query in SOLR to return the results as the above example shows?

I have tried querying as:

q=(street_name:/12[A-Z]\ HILL*/)

but don’t get anything back.

>Solution :

You can use

q=(street_name:/12[A-Z]* HILL.*/)

Here, the pattern means

• 12 – string starts with 12
• [A-Z]* – zero or more ASCII uppercase letters
• – a space
• HILL – HILL char sequence
• .* – any zero or more chars other than line break chars as many as possible (so, the rest of the line).