Order posts alphabetically: how to set order=asc in mysql query?

Question

Why don’t you use WordPress get_posts?

You can add the parameter orderby => ‘title’ as you want.

$args = array( 
    'posts_per_page' => -1, 
    'order'          => 'ASC', 
    'orderby'        => 'title' 
);

$posts = get_posts( $args );

print_r($posts);

If you want the sql you can just add ORDER BY post_title:

SELECT * FROM $wpdb->posts 
WHERE post_type="post" 
AND post_status="publish" 
AND post_title LIKE %s
ORDER BY post_title