search 1000000 rows

hi i am trying to develope a database with a unique field so that when a user inputs a filed i'll have to check through all rows in mysql table. Is it possible to search through like 1000 000 rows to check for identical field or do we have to seperate the tables when the number gets too large?

 

Do you mean something like 'SELECT * FROM table WHERE column="value"' ?

 

yeah i mean is there a limit to the number of rows where we can query suppose it gets very large?

 

The only limit is how much memory / space you have available, the query will require more the larger dataset you are looking through.

However 100k+ rows isnt really that many to be querying against, especially if you are comparing numbers and you have decent indexes set up.