advanced code snippet search

Posted By

dsoms on 05/17/11


Tagged

mysql comma separated


Versions (?)

Search comma separated database column

 / Published in: MySQL
 

For example: searchvalue = 3, columnvalue = 1,2,3,4,5,6

Expand | Embed | Plain Text 
  1. SELECT *
  2. FROM table_name
  3. WHERE FIND_IN_SET(search_value, column_name)

Report this snippet  

You need to login to post a comment.