Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    1

    Question Unanswered: Help with Uppercase query

    Hi All,

    Username
    ========
    AUbRian
    AUCharles
    AUdanny
    AUcinDy
    AUmichael

    These are the sample records from my username field. It always start with 'AU', the problem now is lot of username that has capital letter and I need to sort out all username that only has CAPITAL inside(AUbRian, AUCharles, AUcinDy). Can anyone advise me the query to do that?
    Thanks.

  2. #2
    Join Date
    Jan 2009
    Location
    Dhaka, Bangladesh
    Posts
    51
    if you want to find only those names which has at list one upper case letter you can use regular expression function REGEXP_LIKE

    ORACLE: DBA's day out: Use Regular Expressions in SQL
    Mohammad Hasan Shaharear
    E-mail
    Blog: http://shaharear.blogspot.com

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    dear hasan_uiu

    how confident are you that this oracle function will work correctly in mysql?

    i'll bet you did not even realize that this was the mysql forum

    tip: slow down and pay attention

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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