'USE % WILD IN WHERE CLAUSE
I have a record in my MySQL database which is a varchar type for e.g
john;john;john;jack;jack;steve;steve
I am running a query to fetch this record, say the column name is NAME and table name is DATA. so my query is .........
SELECT * FROM DATA WHERE NAME LIKE '%john;jack;steve%'
But this query isn't fetching any record
Tell me any possible way to fetch this particular record through this '%john;jack;steve%'
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
