Page 1 of 1

Wild Cards * and ? may be used - what does this mean?

Posted: Mon Oct 31, 2011 9:43 am
by Chris Hadden
Under advanced search it says " Wild Cards * and ? may be used" How are those used? what does it mean?

Thanks
Chris

Re: Wild Cards * and ? may be used - what does this mean?

Posted: Mon Oct 31, 2011 2:12 pm
by david-ebt
The * means match one or more characters and the ? means match 1 character.

Take a look at this web page http://www.techonthenet.com/sql/like.php. The % is the same as the * and the _ is the same as the ?. * and ? are standard in regular expressions but SQL uses % and _.

Hope that helps!

Re: Wild Cards * and ? may be used - what does this mean?

Posted: Mon Oct 31, 2011 4:50 pm
by Logan Rhodehamel
If you are doing a search you can use the * character to match any characters. So like when searching users a search of "*@domain.xyz" in the email field would show you all users with some email at the given domain.

Just as an FYI, in the future we are going to move away from supporting the ? wildcard character.

Re: Wild Cards * and ? may be used - what does this mean?

Posted: Thu Nov 03, 2011 10:42 am
by Chris Hadden
Ok thanks, I must say that truly is..... "advanced"... as no customer of mine would ever have the foggiest idea what those search functions are, just serves to confuse them.