In SELECT-FROM-WHERE xx LIKE yy
Are there only two wild character % and _ ?
Is this standard usage?
I am somewhat surprised, since there is regular expression used everywhere, why not use regular expression here?
LIKE
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: LIKE
Most databases also support regular expressions. So you can use either. The LIKE syntax is simpler, but perhaps following the 80/20 rule works most of the time.
(#10850)