CONTAINS Not Working in mysql

Question

I am working with CONTAINS, but it is not woking in mysql.

 mysql> SELECT * FROM MUTHU;
+---------------------+
| MY                  |
+---------------------+
| how is your studies |
| how are you there   |
| hi there            |
+---------------------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM MUTHU CONTAINS ( MY, "how" );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '( MY,
 "how" )' at line 1

Is `CONTAINS` even a real MySQL function, I couldn't find anything about it on their documentation. :S — Seer, Mar 15 '13 at 15:30

score 1 · Answer 1 · answered Mar 15 '13 at 15:42

1

I don't think MYSQL has a function called CONTAINS, try the following query:

SELECT * FROM MUTHU
WHERE MY LIKE '%how%';

answered Mar 15 '13 at 15:42

JodyT

4,324
2
19
31

http://stackoverflow.com/questions/3213998/performance-of-like-query-vs-full-text-search-contains-query – jcho360 Mar 15 '13 at 15:43
1

Mysql has keyword CONTAINS. Please edit your answer. – abhimanyuaryan Mar 10 '15 at 00:53
1

@AbhimanyuAryan Please can you tell me where are documentations on `CONTAINS` keyword??? – Airy Dec 23 '16 at 16:20
This was confusing for me as well. It looks like CONTAINS is not available for MySQL, only other databases like MS SQL. – Stephen Feb 05 '18 at 19:18

score 1 · Answer 2 · answered Mar 15 '13 at 15:52

1

I believe contains is used primarily in Xpath/Xquery. A similar function in mysql is INSTR(). The proper code is for using this is:

    select * from MUTHU
    where INSTR(MY, 'how') > 0;

answered Mar 15 '13 at 15:52

hillmandj

83
2
11

@EAGER_STUDENT in response to your question below, the answer is you'll have to call INSTR twice. like so: where (INSTR(MY, 'how') > 0) or (INSTR(MY, 'hello') > 0 ); – hillmandj Mar 15 '13 at 18:20

jcho360 · Answer 3 · 2013-03-15T18:54:19.673

0

you missed the Where condition,

try this:

SELECT * FROM MUTHU
Where MY CONTAINS ( MY,"how" );

edited Mar 15 '13 at 18:54

answered Mar 15 '13 at 15:38

jcho360

3,724
1
15
24

But I want query like select * from MUTHU where INSTR(MY, 'how' OR 'hello') ; Is there any way? – Muthu Ganapathy Nathan Mar 15 '13 at 17:46

CONTAINS Not Working in mysql

3 Answers3