Search comma separated database column

/ Published in: MySQL
Save to your folder(s)

For example:
search_value = 3,
column_value = 1,2,3,4,5,6

Copy this code and paste it in your HTML
  1. FROM table_name
  2. WHERE FIND_IN_SET(search_value, column_name)

Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.