Hi All

I have custom tables in mysql database. I want to have a view, where I want to show the data from custom tables in a tabular format with certain conditions.

 

Example:

UID	Name	Email ID	Alternate Email ID	Phone number	Alternte phone number	DOB	Years of experience	Preferred work location	Highest Qualification
1	Austin	austi@yahoo.com	au@rediffmail.com	123456789	987654321	1/15/1975	10	Texas	B.E (Electrical)
2	John	john@yahoo.com	jo@rediffmail.com	3333333333	5555555555	2/16/1989	6	Washington DC	BSC
3	Russel	r@yahoo.com	r@rediffmail.com	777777777	99999999	3/8/1987	8	Seoul	MSC

 

 

 

Lets say, in a view I want to show data from this table with a condition.

Let the condition is "people who work in Texas".

 

I have now basic knowledge on views. Can somebody give me a step wise help , how to acheive this.

 

Regards

Austin