MySQL
×あればUPDATE、なければINSERT ○あればDELETE、そのあとINSERT
MySQLで順位付け ただし同一順はなしSET @rank=0;SELECT @rank:=@rank+1 FROM table ORDER BY field 逆LIKESELECT * FROM tabe WHERE 'search' LIKE CONCAT('%',field,'%'); 必要に応じて AND field != ""
×あればUPDATE、なければINSERT ○あればDELETE、そのあとINSERT
MySQLで順位付け ただし同一順はなしSET @rank=0;SELECT @rank:=@rank+1 FROM table ORDER BY field 逆LIKESELECT * FROM tabe WHERE 'search' LIKE CONCAT('%',field,'%'); 必要に応じて AND field != ""