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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
