MySQL 順序 逆LIKE
MySQLで順位付け ただし同一順はなし
SET @rank=0;SELECT @rank:=@rank+1 FROM table ORDER BY field
逆LIKE
SELECT * FROM tabe WHERE 'search' LIKE CONCAT('%',field,'%');
必要に応じて AND field != ""
MySQLで順位付け ただし同一順はなし
SET @rank=0;SELECT @rank:=@rank+1 FROM table ORDER BY field
逆LIKE
SELECT * FROM tabe WHERE 'search' LIKE CONCAT('%',field,'%');
必要に応じて AND field != ""