mysql

[vithiyaraj]

in mysql how can we store multiple value. And from any one of that values should be used for searching the whole record in the table.

[Nile]

I don't know what you mean by storing a multiple value.
A mysql database is made out of 1 thing, that is tables.
There can be how ever many tables you want. For each table there is a field.
Field1 would be info from all the tables in the database. It's confusing... If you already knew all that, and you know exactly what you want, correct me please. Lol... Because I still don't understand completely what you want.
I hope this helps,
Nile