Answers for "full-text search mysql"

SQL
0

enable full text search mysql

ALTER TABLE table_name  
ADD FULLTEXT(column_name1, column_name2,…)
Posted by: Guest on November-08-2020
0

text search in mysql

mysql> CREATE TABLE tutorial (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, 
title VARCHAR(200), 
description TEXT, 
FULLTEXT(title,description)
) ENGINE=InnoDB;
Query OK, 0 rows affected (2.40 sec)
Posted by: Guest on May-06-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language