Mysql Select Query Help

Discussion in 'Databases' started by web-developer, Nov 26, 2010.

  1. #1
    I have one table example product

    Product
    id | description
    1 | test product name,search product
    2 | main article value, read document

    All description value is part of the full string value.
    For multiple value store separated by comma(",")

    And get the full string value in file like below :

    1 : test product name is part of the this table.
    2 : search product is more useful for searching.
    3 : read document is give you clear idea.

    Is this possible to compare full string with database description value which is separated by comma.

    So when we compare first full string "test product name is part of the this table." so we get the id = 1
    and when we compare this "search product is more useful for searching." then get id = 1
    and when we compare this "read document is give you clear idea." then get id = 2

    If this is possible using mysql query then please give me idea or solution to solve this issue.

    Thanks
     
    web-developer, Nov 26, 2010 IP
  2. tnd8

    tnd8 Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    you must put separated character at begin and end of value, like:

    .value 1. value 2. value 3. value4.

    so you can query with: ".search string."
     
    tnd8, Nov 28, 2010 IP