Re: SQL - like vs matches

Posted in 1992

Walt Hultgren {rmy} — Sat, 21 Mar 92 09:05:36 -0500 — source: Informix-list mailing list archive (1991-1998)

Path: emory!samsung!nighthawk.clearpoint.com!transfer!m2c!nic.umass.edu!caen!zaphod.mps.ohio-state.edu!qt.cs.utexas.edu!cs.utexas.edu!sun-barr!male.EBay.Sun.COM!exodus.Eng.Sun.COM!appserv.Eng.Sun.COM!sun!amdcad!weitek!pyramid!infmx!news From: cortesi@informix.com (David Cortesi) Newsgroups: comp.databases.informix Message-ID: <1992Mar20.013508.22861@informix.com> Date: 20 Mar 92 01:35:08 GMT References: <624@shaman.wv.tek.com> Sender: news@informix.com (Usenet News) Reply-To: cortesi@informix.com Organization: Informix Software, Inc. In article <624@shaman.wv.tek.com> halj@hollywood.WV.tek.COM (Hal Jones) writes: > Ok maybe this is silly but I've only used the "MATCHES" keyword in SQL. Today > while I was trying to answer an end-user question I noticed the "LIKE" keyword. > So my question is when should you use one over the other? From what I can tell > they perform the same function just slightly different with "MATCHES" providing > more flexibility with ranges. One difference: LIKE is in the ANSI standard and MATCHES is not. Another: MATCHES supports unix-style classes [a-z]; LIKE does not.