compare values between comma in mysql -
i have table like:
businesses: id name tags 1 ken my, oh, abc 2 jen city, cle, dir 3 sen state, ny, irs ...
i want create query like:
select * businesses name 'ken' , tags = 'oh'
how can value between first , sec comma?
select * businesses name 'ken' , find_in_set('oh',tags);
mysql
No comments:
Post a Comment