Seeing if value at first index is a number <p>I am working on a Wordpress site where 100,000+ spam accounts have been made. Although there are other types as well but many of them seem to have a user name that starts with a number. </p> <p>So I wanted to ask whether there can be a <code>MYSQL</code> query to <code>select/delete</code> all users whose username starts with a number. </p> <p>An extension to this question is that whether those users need to be deleted from the users table only or also the user-meta or other tables.</p> <p>Any help appreciated.</p>