wordpress sql query to get all images under media libary


<?php  
$posts_rows = $wpdb->get_results( "SELECT ID,post_title,post_name,guid FROM wordpress_posts WHERE post_type='attachment'" );
?>