View Full Version : Mysql rlike

11-07-2011, 06:44 PM

At the minute i've got "SELECT * FROM users WHERE username RLIKE '[0-9]'" when i click #

i want it to find all users with !"$%^&*(){}~@:>?< in the name as well as numbers, ive sorted it for letters but i want symbols aswell, can anyone help thanks.

11-07-2011, 07:18 PM
This hasn't a thing to do with PHP, moving to MySQL.
You should simply add those characters you desire to match in the RLIKE. You can choose if you want to add it into the numbers, or make a new query for it.