Display partial database table but allow search of full table

Display partial database table but allow search of full table

berryintlonlineberryintlonline Posts: 2Questions: 1Answers: 0
edited November 2013 in General
My situation is this: I have a database table that has about 8,000 rows. Only about 100 of those rows are commonly used, so right now I have a column in the database tables called 'common' and if this column read '1' then these rows are used to create the DataTables table.

But my question is whether it is possible to create this 'starter' table and then allow the user to use the search to search the entire 8,000 rows in the database table. Basically, if the row wasn't initially populated in the 'starter' table, then search the database for the term entered by the user.

I hope that makes sense. Any idea on how to pursue looking into this functionality?
This discussion has been closed.