uDesign
DjHuSo, avalambor siz bazangizni o`zini qidiruvga moslab indesklashingiz kerak bo`ladi!
Buning uchun bazaga
Kod · SQL1 qator
CREATE FULLTEXT INDEX nomi ON news(nomi);

yuborasiz!
Chiqarish:
Kod · PHP1 qator
$sorov = 'Manga shu yangilik kerak yoki shunga o`xshash yangilik';

Kod · SQL1 qator
SELECT * FROM news WHERE MATCH (nomi) AGAINST ('" . $sorov . "');