Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    5

    Unanswered: search albumName for "maria" (was "i need help, please.")

    i'm not sure what the sql statement should be. can anyone help me out? will appreciate it loads =))).

    ok, i have a table called "album". the attributes, "albumName" and etc are in there.

    then i have a search textbox. i want the the results to closely match the input with the data in the table.

    for example. user enters "maria". then all the results will contain ANYTHING with the word "maria". this include "mariah" or "mariana" or etc.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Code:
    select albumName
      from album
     where albumName like '%maria%'
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    scan, scan, scan scan, lovely scan...blood vikings...

    Oh, wait, that's spam

    never mind
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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