[RSS Feed/News] How to do a select?

[XenForo]

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...

Read more

ادامه مطلب...