×

Discussion Board

Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    Dec 2009
    Posts
    41

    Smile How to: Cace insensitive Query

    Hi,

    I want to make a case insensitive query.

    Like in "SELECT name from mytable where name = 'ganesh'.

    I want the results to be displayed containing all the names in the table with names, Ganesh, ganesh, ganeSh...


    Regards,

    Imran

  2. #2
    Super Contributor
    Join Date
    Oct 2009
    Posts
    4,326

    Re: How to: Cace insensitive Query

    It really matters what kind of database you are using. I guess SQLite,
    then SQL query will be:
    Code:
    SELECT name FROM mytable WHERE name LIKE 'ganesh';

Similar Threads

  1. help in sql query!!
    By raj8nokiaforum in forum Symbian
    Replies: 2
    Last Post: 2010-01-15, 06:57
  2. SQL query Issue
    By kamaljaiswal in forum Symbian
    Replies: 4
    Last Post: 2008-06-25, 09:17
  3. I cannot send query string to the servlet
    By raghda in forum Mobile Java Networking & Messaging & Security
    Replies: 1
    Last Post: 2007-09-10, 07:23
  4. Query regarding pkg file syntax
    By vinayakak in forum Symbian
    Replies: 1
    Last Post: 2006-11-06, 12:14
  5. Multiline Query in 3rd edition sdk
    By parag_purkar in forum Symbian User Interface
    Replies: 1
    Last Post: 2006-09-26, 03:54

Posting Permissions

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