Re: [GENERAL] backslash separated values for a field

2006-02-10 Thread Leif B. Kristensen
On Friday 10 February 2006 12:54, surabhi.ahuja wrote: >is ther any opeartor like contain, so i can form a query of the form: > >select * from table_name where x contains 'abc'; SELECT * FROM table_name WHERE x LIKE '%abc%'; You should probably avoid using backslash as a separator because of its

[GENERAL] backslash separated values for a field

2006-02-10 Thread surabhi.ahuja
Hi,    i have a field "x" which can be of the form   abc\def\123   i.e. they are back slash separated fields   is there any operator in postgres which can process a query like give me all xs where x is abc   is ther any opeartor like contain, so i can form a query of the form:   select * from