need to use resulted comma seperated values to search in database

prasad.mhatre's Avatar


01 Mar, 2012 06:36 AM

Dear Friends,

Ok I got the results from the Autosuggest script like this

100,123,304 etc.

Now I need to use this result to query mysql database and show results of each comma seperated value one row below the other. I have no idea how to get the results using WHERE.

Any help is appreciated.


Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac