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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users