A database has the following data:
Data:,2,3,4,5,6,7 1 or 2,3,4,5,6,7,8 for one, has a lot of article,
Database B has the following data:
Data: 1, 2, 3 occurrences:?
Or June occurrences:? For one, there are a lot of article,
Excuse me, how to achieve statistical data in A database A database B the number of occurrences of the occurrences and saved to the database B,
Require the occurrences and data corresponding to the!

CodePudding user response:

 
Select COUNT (1) the FROM TABLE1 WHERE ', '+ COL1 +', 'LIKE' % %, 1, 2, 3, '

This?

CodePudding user response:

reference 1st floor assky124 response:

 
Select COUNT (1) the FROM TABLE1 WHERE ', '+ COL1 +', 'LIKE' % %, 1, 2, 3, '

This?

Not, is to develop the JAVA code in the android!

CodePudding user response:

Completely white, SQLite can also write a SQL query

CodePudding user response:

 select count (1) the from table1 where col1 like '% % 1, 2, 3 or cont like' % % June; 

For matching contains 123, or 678 include all the number,

CodePudding user response:

reference assky124 reply: 3/f

completely white, SQLite can write SQL query statement.

Well! Completely white, self-study android now, thank you!

CodePudding user response:

reference assky124 reply: 3/f

completely white, SQLite can write SQL query statement.

What can you tell me how to write in to android?

CodePudding user response:

reference 4 floor silently loading response:

 select count (1) the from table1 where col1 like '% % 1, 2, 3 or cont like' % % June; 

For matching contains 123, or 678 include all the number,

Database B not only contains the two, there's more!