1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    Is there any "select" statement to make a case-sensitive query. The command whisch i gave is...
    "select * from (table) where name=(variable)"
    which returns all the records where name is equal to the varibale value irrespective of case. What i want is to return all records matching the criterion keeping cases into consideration.

    Pl. help...
  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    Take a look at the REGEXP command in the MySQL manual, this should be able to help solve your problem.

Similar Threads

  1. case sensitive problem with URLs
    By theDano in forum PHP Development
    Replies: 3
    Last Post: January 17th, 2004, 06:46 AM
  2. mod_rewrite and case sensitive
    By dstonek in forum Apache Development
    Replies: 4
    Last Post: November 9th, 2003, 01:37 PM
  3. case sensitive strpos
    By retroman in forum PHP Development
    Replies: 3
    Last Post: March 22nd, 2002, 09:44 AM
  4. Making case-sensitive query
    By deewana_mastana in forum MySQL Help
    Replies: 0
    Last Post: July 1st, 1999, 06:48 AM

IMN logo majestic logo threadwatch logo seochat tools logo