MySQL Forums
Forum List  »  Newbie

Re: Find number between 1-10 in data
Posted by: John Walpole
Date: June 03, 2014 09:43PM

Not exactly. My table has a colum with:
id | Name | logo | fk_location_ids | enabled
1 | Test Group | logo.jpg | 1-10 | Yes

I have a location table that has:
id | Location name
2 | Test Site


When I select from the from I am getting the location id of 2 and need to find out what group or groups the location belongs to. Since 2 is between 1-10, I should get the test group returned in the result set.

FIND_IN_SET and IN doesn't seem to know to look in that whole through (-) grouping of 1 thru 10.

Mysql server ver 5.1

Options: ReplyQuote


Subject
Written By
Posted
Re: Find number between 1-10 in data
June 03, 2014 09:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.