Database Reference
In-Depth Information
We click the
Edit
link (small pencil) on the line containing the
author_id
index; this
shows the current state of this index. The interface has room to add another field
to this index. We could use the
Add to index 1 column(s)
feature should we need
to add more than one field. In the field selector, we select
language
. This time we
do not have to enter a size, as the whole field will be used in the index. For better
documentation, we change the
Index name
(
author_language
is appropriate).
We save this index modification. In the list of indexes, we can confirm our index
modification.
FULLTEXT Indexes
This special type of index allows for fulltext searches. It is supported only on
MyISAM
tables for the
VARCHAR
and
TEXT
fields. We can use the
Fulltext
quick link
in the fields list or go to the index management panel and choose
Fulltext
in the
drop-down menu.
We add a FULLTEXT index on the description field, so that we are able to locate
a book from words present in its description.
Search WWH ::
Custom Search