we can create the database views for many reason, but if we forget what query you was used to create the views or need to find out using which query results are generating here is the solution:
Below are the simple query to run and you will get the query:
SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'yourviewname'
instead of 'yourviewname',type your views name to get the result.
If you are using phpmyadmin then long query will not fully visiable, so use full text to see whole query like below image
Hope article helps, thanks
Please Comment your thoughts and feedback below and add something if you found good in anywhere to help others
Hit a like Button If you like the Post.