do mysql create another table when selecting rows?if this happens it will take up lot more space on hard disk as duplicate entries will be risiding in table formed by "select"...
No, MySQL does not create new rows unless you tell it to.
Either you are using the wrong query to get your data or something is seriously wrong with your installation (unlikely).
Can you show an example of a query you're using and how it affects the db?
select email from tablename where products LIKE %product1% && products LIKE %product2% && products LIKE %productn%
Not sure what is that query? The reason is that it will very likely return an empty row back because of your WHERE clause...
My question is, why do you think it will create new "table" (not "row")? What functionality or command are you using that implies what you said?
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.