FIND_IN_SET for part of string in Mysql

Question

I need to make a query to a table in my database. Until now I was using FIND_IN_SET because I have strings like this: "twitter,bycicle,car".

Then, I could search by FIND_IN_SET("twitter", nameOfColumn)

But now, I need to search just part of each "set", for example: "twitter>10,bycicle,car"

It still works fine for bycicle and car but if I need to search for twitter, I cannot find it. What is the correct way to do this?

If you have another symbol( not comma ) inside string so `FIND_IN_SET()` don't work, instead you can use from `substring_index`. — Mobasher Fasihy, Dec 04 '14 at 10:41
This [link](http://stackoverflow.com/questions/26748845/mysql-split-string/26750049#26750049) is the same problem that i answered in the past, may help u. — Mobasher Fasihy, Dec 04 '14 at 10:49

score 1 · Accepted Answer · answered Dec 04 '14 at 10:45

1

The following query would give you what you want, however use it with caution with respect to the data you have:

SELECT *
FROM table1
WHERE col1 RLIKE 'twitter'

answered Dec 04 '14 at 10:45

Aziz Shaikh

I didn't want to use LIKE because of that, maybe there are some similar strings and it make confusion. If I have no other way, I will use it – Biribu Dec 04 '14 at 11:01
@Biribu to slightly improve it, you may also try this: `RLIKE 'twitter.*,?'` – Aziz Shaikh Dec 04 '14 at 11:07
I have problems with words shorter than the contained in db. If I try with "twit", I get in return the row... – Biribu Dec 04 '14 at 11:26

score 0 · Answer 2 · answered Dec 04 '14 at 10:46

0

Use LIKE operator:

SELECT *
FROM table1
WHERE nameOfColumn LIKE '%twitter%';

answered Dec 04 '14 at 10:46

Saharsh Shah

2 Answers2