Thursday, 15 January 2015

compare values between comma in mysql -



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