SELECT category, title, tags, link_alias, SUBSTRING(SUBSTRING(full_text, POSITION('ssl sertifikasi' IN full_text), 350),1, LENGTH(SUBSTRING(full_text, POSITION('ssl sertifikasi' IN full_text),350))-POSITION(' ' IN REVERSE(SUBSTRING(full_text, POSITION('ssl sertifikasi' IN full_text), 350)))) as full_text, table_date, MATCH (full_text) AGAINST ('*ssl sertifikasi*' IN NATURAL LANGUAGE MODE) AS score FROM search WHERE MATCH(full_text) AGAINST ('*ssl sertifikasi*' IN NATURAL LANGUAGE MODE)>0 ORDER BY score DESC array(3) { ["type"]=> string(17) "SUCCESS_WITH_DATA" ["count"]=> int(2) ["data"]=> array(2) { [0]=> array(7) { ["category"]=> string(8) "İçerik" ["title"]=> string(14) "Domain Hosting" ["tags"]=> string(0) "" ["link_alias"]=> string(26) "icerik/domain-hosting.html" ["full_text"]=> string(0) "" ["table_date"]=> string(19) "2024-08-21 12:19:08" ["score"]=> string(18) "0.2960100471973419" } [1]=> array(7) { ["category"]=> string(8) "İçerik" ["title"]=> string(9) "E-Ticaret" ["tags"]=> string(0) "" ["link_alias"]=> string(21) "icerik/e-ticaret.html" ["full_text"]=> string(0) "" ["table_date"]=> string(19) "2024-08-21 12:20:33" ["score"]=> string(18) "0.2960100471973419" } } } Web Site |

İçerik

Domain Hosting

2024-08-21 12:19:08

İçerik

E-Ticaret

2024-08-21 12:20:33