Shulou(Shulou.com)06/01 Report--

1:array_filter checks whether each element is a number or not

If (array_filter ($this- > data ['log_id'],' is_numeric')! = $data ['log_id']) echo' 000'

2:concat connection string, ifnull, if usage

Update log

Set users = concat (ifnull (users,''), if (users,',411','411'))

Where log_id between 453729 and 453740

3:find_in_set queries whether id is in the id collection

SELECT

*

FROM

Log

WHERE

Log_id BETWEEN 453729

AND 453740 and! find_in_set ('2percent and if null (l.users, "))

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.