MySql query contains a string in field

Question

The question may be asked several times and I checked all of them but I can't get the answer. I have a field named variables in my database 'test'.I have worked the query

select 'variables' from test WHERE variables LIKE '%{$ifIndex}%';

variables field contains comma seperated strings like ifIndex, IfType, IfStatus but I can't get it!

Jason · Accepted Answer · 2020-05-20 19:27:07Z

5

This will achieve the results you want when you put the string you are looking for using just the % for the wildcard on either side.

select variables from test WHERE variables LIKE '%ifIndex%';

edited May 20, 2020 at 19:27

Jason

871 silver badge9 bronze badges

answered Feb 13, 2013 at 5:50

Hamlet Hakobyan

33.5k6 gold badges55 silver badges70 bronze badges

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

Comments

Tucker · Accepted Answer · 2013-02-13 05:48:10Z

3

Try the following:

select variables from test WHERE 'ifIndex' LIKE CONCAT('%',`variables` , '%') ;

if you're trying to match just the start:

select variables from test WHERE 'ifIndex' LIKE CONCAT(`variables` , '%')

answered Feb 13, 2013 at 5:48

Tucker

7,38210 gold badges40 silver badges61 bronze badges

3 Comments

Nikhil Over a year ago

What about if the field contains space. can i replace it when querying?

Tucker Over a year ago

what do you mean by field? like the field name? or the value in the field being searched? If its the field name, you should dhave no problem. Otherwise, you need to take into account regular expressions.. see dev.mysql.com/doc/refman/5.0/en/…

Nikhil Over a year ago

i mean sometimes the 'variable' in the table contains ' ifIndex'

Madhav · Accepted Answer · 2013-02-13 05:51:13Z

3

Try the following code

select variables from test
WHERE variables LIKE '%{$ifIndex}%';

For field names don't put the single quotaition.

answered Feb 13, 2013 at 5:51

Madhav

2,4153 gold badges19 silver badges16 bronze badges

Collectives™ on Stack Overflow

MySql query contains a string in field

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related