Need SQL reg exp for keyword search on a MS ACCESS db
Moderator: General Moderators
-
bnownlater
- Forum Newbie
- Posts: 4
- Joined: Thu Jan 02, 2003 2:22 pm
- Location: Orlando, FL
Need SQL reg exp for keyword search on a MS ACCESS db
I am using an MS Access db. I want to use a regular expression to find the keywords in a phrase, but only if they are the start of any word in that phrase. I was prevoiusly give REGEXP '[[:<:]]".$keyword."'", but this will only work for a mySql db. Please help. Thanks.