Edit

EN: Categories -meta -edit   |  Productdescriptions  - meta -edit  | Contents - edit | Productoptions & - values | reviews

--------------
UPDATE `products_content`
SET `group_ids`= "c_all_group"

WHERE `group_ids` IN  ("c_all_group,c_0_group,c_1_group,c_2_group,c_3_group,c_4_group,c_5_group,c_6_group,c_7_group,c_8_group,c_9_group,c_10_group,c_11_group,c_12_group,")


Oder Besser noch % steht f�r alles in LIKE statement:

----------------
UPDATE `products_content`
SET `group_ids`= "c_all_group"
WHERE `group_ids` LIKE  "c_all_group,%"

--------------------


Oder konktret spezifisch (funktioniert auch)

------------
UPDATE `products_content`

SET `group_ids`= 
"
c_all_group,
c_0_group,
c_1_group,
c_2_group,
c_3_group,
c_4_group,
c_5_group,
c_6_group,
c_7_group,
c_8_group,
c_9_group,
c_10_group,
c_11_group,
c_12_group,
c_13_group,
c_14_group,
c_15_group,
"
WHERE `group_ids` IN 
("c_all_group")

---------------------------


Um zu filtern:

SELECT *
FROM `products_content`
WHERE `group_ids` 
NOT LIKE ("%c_all_group%") 
AND `content_name` NOT LIKE ("%Zugangsinfo%")



UPDATE `products_content`

SET `group_ids`= "
c_all_group,
c_0_group,
c_1_group,
c_2_group,
c_3_group,
c_4_group,
c_5_group,
c_6_group,
c_7_group,
c_8_group,
c_9_group,
c_10_group,
c_11_group,
c_12_group,
c_13_group,
c_14_group,
c_15_group,
c_16_group,
c_17_group,
c_18_group,
c_19_group,
c_20_group,
c_21_group,
c_22_group,
c_23_group,
c_24_group,
c_25_group,
"
WHERE `group_ids` LIKE  "c_all_group,%"


----------- 
SELECT�`group_ids`�
FROM�`products_content`�
WHERE�`file_comment`�LIKE�"