Find occurrence of a substring in string in MySQL?

Question

I'm using this query to getresults from my database:

MATCH(`Text2`) AGAINST ('$s')

I want to get only results when there is a full match of the string, like when on google when you search between quotes "".

How can I do this with Match/MySQL?

EG: Query is "ab cd"

ID | Text
1    ab cd
2    aab cda
3    aab a cd

Row 1 and 2 should be returned

Radu Murzea · Accepted Answer · 2012-07-14 08:06:54Z

3

SELECT FROM your_table WHERE Text2 LIKE '%yourstring%';

Radu Murzea

11k10 gold badges50 silver badges72 bronze badges

answered Jul 14, 2012 at 7:57

ZeeCoder

9819 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sashi Kant · Accepted Answer · 2012-07-14 08:43:00Z

0

Try this:: If you need the wild search irrespective to the cases ::

SELECT FROM LOWER(mytable) WHERE LOWER(Text2) LIKE LOWER('%yourstring%');

answered Jul 14, 2012 at 8:43

Sashi Kant

13.5k9 gold badges50 silver badges71 bronze badges

hjpotter92 · Accepted Answer · 2012-07-14 08:52:53Z

0

You can use REGEXP for this purpose too.

SELECT *
FROM `tableName`
WHERE `columnName` REGEXP 'ab cd';

answered Jul 14, 2012 at 8:52

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges