Answer Posted / jagpreet

MySQL has support for full-text indexing and searching. A
full-text index in MySQL is an index of type FULLTEXT.
FULLTEXT indexes can be used only with MyISAM tables; they
can be created from CHAR, VARCHAR, or TEXT columns as part
of a CREATE TABLE statement or added later using ALTER
TABLE or CREATE INDEX. For large datasets, it is much
faster to load your data into a table that has no FULLTEXT
index, and then create the index afterwards, than to load
data into a table that has an existing FULLTEXT index.

Constraints on full-text searching are listed in Section
12.7.4, “Full-Text Restrictions”.

Full-text searching is performed with the MATCH() function.

mysql> CREATE TABLE articles (
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY
KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)
-> );

What is $$ in php?

1027

---

Is python similar to php?

1092

---

What is put method in php?

1054

---

What are the 5 types of variables?

1086

---

What are php data types?

1038

---

What is the function mysql_pconnect() usefull for?

1191

---

What is the correct php command to use to catch any error messages within the code?

1121

---

What does nan stand for computer science?

1044

---

What is the actually used php version?

1192

---

How is it possible to return a value from a function?

1078

---

What is the difference between mysql_fetch_array() and mysql_fetch_assoc()?

1122

---

What is regex in html?

975

---

What is php namespace?

1042

---

How does the identity operator ===compare two values in PHP?

1168

---

Require_once(), require(), include(). What is difference between them?

1035

---