creat view in mysql


[php]
CREATE VIEW `view_name` AS SELECT `table_name`.* FROM `table_name` WHERE (`table_name`.type = ‘something’) ;
[/php]