My current query for selecting names starting with "A" reads something like this:
Code: Select all
SELECT * FROM users WHERE username like "A%"Moderator: General Moderators
Code: Select all
SELECT * FROM users WHERE username like "A%"Code: Select all
SELECT * FROM users WHERE SUBSTRING(username,1,1) NOT REGEXP "їa-zA-Z]"