[ic] pgsql - sql query with regular-expression
Chen Naor
chennaor@netvision.net.il
Thu, 1 Feb 2001 01:32:05 +0200
Hi,
using postgresql 7.0.3.
I'm trying to use regular-expression in a sql queries - is it possible in
minivend/interchange? (it works in pgsql)
This is what I'm trying to do, but I fail:
[query
list=1
st=db
sql=|
SELECT COUNT(*) FROM products
WHERE category = 'BOGU' and countries like ~
'[^A-Z]*(AT)[^A-Z]*' |
]
[sql-param count]
[/query]
Thanks
Chen Naor
Lilux Systems.
http://www.lilux.co.il
email: chen@lilux.co.il