开发者

SQL exact match within a pattern?

I am using qodbc (a quickbooks database connector) It uses an ODBC-like sql language.

I would like to find all the records where a field matches a pattern but I have a slight delema.

The informat开发者_StackOverflow社区ion in my field looks like this:

 321-......02/25/10
 321-1.....02/26/10
 321-2.....03/25/10
 321-3.....03/26/10
 322-......04/25/10
 322-1.....04/26/10
 322-2.....05/25/10
 322-3.....05/26/10

I would like my query to return only the rows where the pattern matches the first number. So if the user searches for '321' it will only show records that look like 321 but not those that have 321-1 or 321-3. Similarly if the user searched for 321-1 you would not see 321. (that's the easy part)

Right now I have

 LIKE '321%'

This finds all of them regardless of if they are followed by dots or not. Is there a way I can limit the query to only specifics despite that field having more information that it should.

(P.S. I did not set up this system, it makes me wince to see two data points in one field I'm sorry if my title isn't right, suggest a new title if you can. )


LIKE '321%' AND NOT LIKE '321-%'

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜