can i use view instead of table?

[eluser]mario simaremare[/eluser]
dear all,
i am looking for answers about using view instead of table, any one knows?
i mean to retrieve information from it [view].

thanks.

[eluser]Hernando[/eluser]
You can use a view, but you need mySql 5+

[eluser]InsiteFX[/eluser]
This is in the Users Guide!

Views

Look at the very bottom of the page...

InsiteFX

[eluser]mario simaremare[/eluser]
thanks for hernando and a giant question mark for InsiteFX, sorry.
i've tried using view instead of table, it's better than create a very complex query then execute it.

thanks!