How do i search comma separated data in MySQL [duplicate]

51
October 25, 2019, at 1:10 PM

This question already has an answer here:

  • PHP: search comma separated string in mysql? 2 answers
  • Mysql search with comma delimited string 3 answers

i have table for products in my database and in that their is a column 'tags' which have values like - men,clothes,t-shirt and i want to search that product through these values when some one search for man or boy or t-shirt or any of them please help.

i have tried LIKE in queries but it wont work.

READ ALSO
Is there any regex to grab the names from alpha-numeric file name

Is there any regex to grab the names from alpha-numeric file name

I have to write a regex in SQL to filter and capture the file name and exclude the date stamps and the file fromat, is there any way we can do that? the examples I have are-

28
Emulate an Intersect in MySQL w/ multiple tables and Join

Emulate an Intersect in MySQL w/ multiple tables and Join

I need to emulate an Intersect query in MySQL

44
Write Pandas DataFrame into a existing MySQL Database Table

Write Pandas DataFrame into a existing MySQL Database Table

I have created a database using phpmyadmin called test that has one table called client_infoThe table in that database is empty (as shown in the attached image)

28
SIGSEV signal recieved printing a result in C with the MySQL API

SIGSEV signal recieved printing a result in C with the MySQL API

After having spent hours on my own trying to solve the problem and asked programming teachers in my university, I'm coming here hoping to find some help

57