Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: Mysql rlike

  1. #1
    Regular Coder
    Join Date
    Jun 2010
    Location
    Sutton-in-ashfield, Notts
    Posts
    117
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Mysql rlike

    Right,

    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.

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,979
    Thanks
    4
    Thanked 2,659 Times in 2,628 Posts
    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.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •