Buning uchun bazaga
Kod · SQL
CREATE FULLTEXT INDEX nomi ON news(nomi);yuborasiz!
Chiqarish:
Kod · PHP
$sorov = 'Manga shu yangilik kerak yoki shunga o`xshash yangilik';Kod · SQL
SELECT * FROM news WHERE MATCH (nomi) AGAINST ('" . $sorov . "');CREATE FULLTEXT INDEX nomi ON news(nomi);$sorov = 'Manga shu yangilik kerak yoki shunga o`xshash yangilik';SELECT * FROM news WHERE MATCH (nomi) AGAINST ('" . $sorov . "');