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
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."