www.webdeveloper.com
Results 1 to 3 of 3

Thread: Like

  1. #1
    Join Date
    Jan 2003
    Posts
    69

    Arrow Like

    What are the rules to use like.

    Does like work in two condition and and operator also.

    Like select from User where name="John" and hobbies like "%Football%";

    Where hobbies is a long string with comma seprated multiple values.


    This will work or not?
    Programer,
    Sunita.

  2. #2
    Join Date
    Dec 2002
    Location
    Pleasanton, CA
    Posts
    2,132
    Yes and No
    The wildcard chars are correct but your expression is in error. Select what??

    SELECT ??? FROM User WHERE name="John" AND hobbies LIKE "%Football%"

  3. #3
    Join Date
    Jan 2003
    Posts
    69

    Smile

    tHANKS SOMETIMES YOU MISS BASIC THINGS AND START WORKING ON COMPLEX THINGS.

    iT WORKED.
    Programer,
    Sunita.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles