SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: Query w/ LIKE

  1. #1
    SitePoint Addict
    Join Date
    Feb 2006
    Posts
    247
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Query w/ LIKE

    Hey guys,

    I'm trying to search my database for words that are similar to search terms. For example. If i have an item named "Red Silk" and someone searches for "The Red Silk Lounge" ... how to do I get "Red Silk" as a potential result... is it with the LIKE command?
    I live in Madison. Where in the W1RLD do you live?

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    a FULLTEXT index would do that.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  3. #3
    SitePoint Addict
    Join Date
    Feb 2006
    Posts
    247
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks longneck, i'll look into it
    I live in Madison. Where in the W1RLD do you live?

  4. #4
    SitePoint Addict
    Join Date
    Feb 2006
    Posts
    247
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SWEET! it works perfectly. I thought it was going to be hard to implement, but it was a sinch. Thanks again!
    I live in Madison. Where in the W1RLD do you live?


Bookmarks

Posting Permissions

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