[GRASS-user] where clause in v.extract for '*'

[Hamish]

Juan Miguel Garijo wrote:
> In a vector map there is a text field with values
> like:
> 
> xxxx
> xxxx
> xxxx*
> xxxx(*)
> 
> I need to select all values wich finish with '*' OR
> '(*)' 
> 
>  (without '')
> 
> Wich 'where' clause can I use in v.extract?
> I see that is not the same if you write it in console
> or throu gis.m
> 
> Driver:dbf


I don't know if there is a regex '$'-like character in SQL to denote
end of string match, but you can use

where COLUMN ~ '*'

to select strings which contain a '*'  (? perhaps; I'm no SQL expert)


try looking in the SQL reference guide:
http://www.redhat.com/docs/manuals/database/RHDB-2.1-Manual/sql/sqlreference.html


Hamish



      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs