Select * from mytable where c5 like '9806067880' OR c6 like '9806067880' OR c7 like '9806067880';
AFAIK, like function should called for each column. Regards, Yongil Jang. 2013/2/8 YAN HONG YE <[email protected]> > my table has a table like this: > c5 c6 c7 > 9806062380 9806062380 9806062380 > 9806062480 9806062680 9806062680 > 9806063280 9806068980 9806068980 > 9806062980 9806067980 9806067980 > 9806062280 9806067880 9806067880 > 9806734080 9806068280 9806068380 > 9806069180 9806068380 9806068680 > 9806063180 9806068680 9806635280 > > I wanna to find in the column c5,c6,c7 include 9806067880 like this: > > select * from mytable where * like '9806067880'; > > it's right? > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
