mysql常用命令

UPDATE ulala_room_list AS a,
 (
    SELECT
        li.id,is_star,sort
    FROM
        ulala_user_info AS i
    LEFT JOIN ulala_room_list AS li ON i.uid = li.uid
) AS b
SET a.sort = IF(is_star=1,99,0)
WHERE a.id=b.id

SELECT
    *
FROM
    {table_name_1} bol
LEFT JOIN {table_name_2} bmo1 ON (
    bmo1.options_id = SUBSTRING_INDEX(bol.options_id, ',', 1)
)
LEFT JOIN {table_name_2} bmo2 ON (
    bmo2.options_id = SUBSTRING_INDEX(bol.options_id, ',', - 1)
)
WHERE
    {condition}

SELECT * FROM articles WHERE category_id = 123 ORDER BY id LIMIT 50, 10;

SELECT * FROM articles WHERE  id >=  
(SELECT id FROM articles  WHERE category_id = 123 ORDER BY id LIMIT 10000, 1) LIMIT 10