How can we help you today? How can we help you today?

wildcard search possible?

Hi

I was searching for a objects corresponding to a patter this morning. Would it be possible (or is it already) to search using wildcards?

For example, I would have like to search for everything starting with UP_object and ending with Read (something like UP_object*Read).
emoreau
0

Comments

5 comments

  • Alex D
    Hi,
    We tried to keep the search more similar to modern web searches, and avoid hidden features. You can of course put a space between the two parts of your search, and it'll find the same results (as long as the exact checkbox isn't checked).

    That way, it will also find results where the two search terms are in the opposite order, but I imagine that's rare?

    Does anyone else have any preference about this?

    Cheers,
    Alex D
    0
  • emoreau
    so the space is the wild card. it makes sens when compared to search engine like Google but not when you are minded to SQL!
    emoreau
    0
  • David Atkinson
    emoreau wrote:
    so the space is the wild card. it makes sens when compared to search engine like Google but not when you are minded to SQL!

    The space isn't really the wildcard. Searching for two words separated by a space will OR them. This is what Google does, for example.

    We appreciate that it goes against the standard SQL wildcards. I'd be interested to hear from other people with regards to what they would find most intuitive. Please tell us your preference.

    David Atkinson
    Product Manager
    David Atkinson
    0
  • AndrewRMClarke
    A lot of us investigate databases using build scripts in text editors, and do complex searches using Regexes. However, I only do this rarely, and would be happy to forgo regex in SQL Search for the time being. I can always go back to the technique of using a text editor when I need to do something fancy.
    AndrewRMClarke
    0
  • dneasley
    google ANDs the results, not ORs
    here is a link to googles search tools

    http://www.google.com/support/websearch/bin/answer.py?answer=136861

    while google does allow wildcards(*) they only do it for whole words. which might not be that useful in sql searches

    i would love to see regex used in a future release of this
    dneasley
    0

Add comment

Please sign in to leave a comment.