full-text검색
PHP 2009. 9. 9. 11:35
select match(text), * from `board` where match(txt) against('|97|')
또는
SELECT *, MATCH(text) AGAINST('|97|') FROM table WHERE 1;
또는
SELECT * FROM board WHERE MATCH (search) AGAINST ('+우리* +나라*' IN BOOLEAN MODE) order by no DESC
