Programming in mysql: Different mysql join query based on user level on newest questions tagged mysql – Stack Overflow
I’m seeking an idea or best practice to perform the below:
I have the tables:
profile contains basic info (id, email, pass, lvl)
profile_user contains (pid, name, age, etc..)
profile_mod contains (pid, company_name, money, etc..)
as you can see that I will do left join on two tables to get the whole information, but the join will be all based on the attribute lvl. If lvl=1 it will leftjoin on profile_user and lvl=2 will perform join on profile_mod.
My question is, I don’t want to perform a check on every query to get the lvl and then do the leftjoin on the other two tables. I was wondering if there is a best practice for such case.
Programming in mysql: programming-in-mysql