Okay, but then for each job, you have a 61-column row in another table.
cf Steve Ruby's and Vivek's comments- a two-column row per state per job.
Normal(ized) is good.
-David (eh)
On Mon, 6 Mar 2000, David VanHorn wrote:
At 02:03 PM 3/6/00 -0800, Mark R. Cervarich wrote:
A CHAR(2) or CHAR(3) would work **IF** each job could appear in only
one state....however, I need to allow a single job to appear in
multiple states, possibly even all 50!
What about a CHAR(150), where I could add in states separated by
commas?
How about a table with 50 entries for states, and some more for provinces
eh? and a reference that ties it back to the job listing.
ref,st1,st2..............bc-eh :)
That way, all you need in each state field is a boolean.
9 messages in com.mysql.lists.mysqlRe: Best way to save 1..50 states int...