Question: i am use mysql full text on link column

but some time text match and some time its not working

i have example

<http://sqlfiddle.com/#!9/470eb28/6>

```
CREATE TABLE domains
    (`name` varchar(300))
 ENGINE=InnoDB;

INSERT INTO domains
    (`name`)
VALUES
    ('https://www.google.com'),
    ('https://www.yahoo.com'),
    ('https://www.instagram.com/painfreestrength/')
;

CREATE FULLTEXT INDEX idx_1 ON domains (`name`);

```

query

```
select * from domains where match(name) against('"painfrees"')

```

Answer: 
Match against will require you to use whole word

```
select * from domains where MATCH(`name`) AGAINST('wholeword') 

```

i.e. for your case

```
select * 
from domains where MATCH(`name`) AGAINST('"https://www.instagram.com/painfreestrength/"')

select * 
from domains where MATCH(`name`) AGAINST('"painfreestrength"')

select * 
from domains where MATCH(`name`) AGAINST('"instagram"')

```

But to if you must use `painfrees`

use `like` or `regex`

```
select * from domains where name like "%painfrees%"

select * from domains where REGEXP_LIKE(name, 'painfrees')

```
Try This

```
select * from domains where name like '%painfrees%';

```