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
special meaning as an escape character. That may bite you in several
ways.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE