-
本人由于涉及到多个语种领域,很容易搞混一些语言的写法,记录下来随时用:
#1 模糊查询 LIKE
SELECT * FROM lj_daily WHERE ad_account_name LIKE '%3%' ORDER BY self_write_date DESC;
#2 查询排序 ORDER BY
SELECT * FROM lj_daily WHERE ad_account_name LIKE '%3%' ORDER BY self_write_date DESC;
#3 运算符查询【常用的如 大于>,小于<, 不等<>,等于=】
SELECT * FROM lj_daily WHERE ad_account_id=32 ORDER BY self_write_date DESC;
运算符如下:
#4 join查询
参见 MySQL七种join写法 https://blog.csdn.net/weixin_41827162/article/details/87871882
-