- تاریخ ثبتنام
- 2020-06-26
- نوشتهها
- 21,420
- راهحلها
- 27
- پسندها
- 3,264
- امتیازها
- 113
- سن
- 27
- محل سکونت
- England
- وب سایت
- xenforo.xyz
Some thoughts from a beginner about a mysql-query.
Lets say i need some new fields for xf_user.
Which colors do you like?
red, green, blue, yellow, grey, orange
1. I could add now some fields like:
xf_user.red
xf_user.green
xf_user.blue
xf_user.yellow
(or color1, color2, color3)
select * from xf_user where red = 1 AND green=1
but we dont like to have so many new fields here.
2. I could add a textfield
xf_user.colors with value "greenbludyellow"
select * from...
Lets say i need some new fields for xf_user.
Which colors do you like?
red, green, blue, yellow, grey, orange
1. I could add now some fields like:
xf_user.red
xf_user.green
xf_user.blue
xf_user.yellow
(or color1, color2, color3)
select * from xf_user where red = 1 AND green=1
but we dont like to have so many new fields here.
2. I could add a textfield
xf_user.colors with value "greenbludyellow"
select * from...
نام موضوع : How to do a select?
