开发者

Sybase 12: REGEXP search condition not understood

I'm using Sybase 12.5.3, and want/need to do regex pattern matching.

The Sybase help says that regex features have been there since version 11, but I cannot get anything to work.

This document describes the REGEXP and SIMILAR TO search conditions. I have tried both of these with no success, on various tables.

As an example:

SELECT * 
  FROM REPORTS 
 WHERE name regexp '开发者_如何学Python.*' 

...gives me an error:

Incorrect syntax near 'regexp'.

The only search results for that error are related to MS-SQL.

I've tried various things, including using REGEXP_LIKE and SIMILAR TO, but I get the same sort of error, as if that word is not understood. Am I missing something? The column I'm comparing contains strings.

I can't find any option to enable/disable these features either, and the actual string I'm supplying has no bearing on it.

I'm using DBArtisan 8.7.5 if that's relevant.


Your link goes to a Sybase Anywhere manual but the 12.5.3 you are using? Well that looks like a Sybase ASE version number. Totally different products - I don't think ASE supported Regex till ASE 15. If you are using ASE you'll need to find a different way to do this.


You can use like instead of a function and provide a regular-expression-like character class matching - e.g. name like "[0-9]"

See the docs: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1520/html/iqrefbb/CACGCGGC.htm


It could be regexp('.*'), but after looking at the Sybase manual for 12.5.x, I don't think that version has a regexp method.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜