Обсуждение: Wild Cards
I am not able to get Wildcards in PostgreSQL, I know its * (asterisk), but its not working. can someone show me a example or something?
On Thu, 25 Jan 2001, <No Name> wrote: > I am not able to get Wildcards in PostgreSQL, I know its * (asterisk), but > its not working. can someone show me a example or something? Wildcards where? You can use * to mean all the fields in a table in a SELECT statement, but if you are using LIKE in a WHERE clause, the wildcards are % to mean any group of characters and _ to mean any single character. -- Brett http://www.chapelperilous.net/~bmccoy/ --------------------------------------------------------------------------- It's a good thing we don't get all the government we pay for.
On Thu, Jan 25, 2001 at 02:29:55PM -0500, Brett W. McCoy wrote: > On Thu, 25 Jan 2001, <No Name> wrote: > > > I am not able to get Wildcards in PostgreSQL, I know its * (asterisk), but > > its not working. can someone show me a example or something? > > Wildcards where? You can use * to mean all the fields in a table in a > SELECT statement, but if you are using LIKE in a WHERE clause, the > wildcards are % to mean any group of characters and _ to mean any single > character. Although, of course, you can use POSIXlish regexps with the ~* and ~ operators. -- Rodger Donaldson rodgerd@diaspora.gen.nz "My mother made me a lesbian" "Oh goody! If I buy her the wool, will she make me one too??"