Problem matching strings with MySQL

Question

I am having trouble matching strings in MySQL. I have the following:

SELECT ea.* 
FROM epf_application ea 
    JOIN epf_application_device_type ead ON ea.application_id = ead.application_id
    JOIN epf_device_type edt ON ead.device_type_id = edt.device_type_id 
WHERE 
    edt.name = 'someDevice'
LIMIT 30

I would like to filter the above results even further by adding ea.title='%tele%' to the above sql statement like the following

SELECT ea.* 
FROM epf_application ea 
    JOIN epf_application_device_type ead ON ea.application_id = ead.application_id
    JOIN epf_device_type edt ON ead.device_type_id = edt.device_type_id 
WHERE 
    edt.name = 'someDevice' AND ea.title='%tele%'
LIMIT 30

The above sql statement doesn't return anything, however when I do the following I get a result.

SELECT ea.* 
FROM epf_application ea 
    JOIN epf_application_device_type ead ON ea.application_id = ead.application_id
    JOIN epf_device_type edt ON ead.device_type_id = edt.device_type_id 
WHERE 
    edt.name = 'someDevice' AND ea.title='television'
LIMIT 30

Any suggestions on what I might be doing wrong?

joekrell · Accepted Answer · 2011-06-24 00:42:11Z

3

Change it to

ea.title LIKE '%tele%'

answered Jun 24, 2011 at 0:42

joekrell

3412 silver badges4 bronze badges

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

1 Comment

David Over a year ago

I can't believe I missed that. Thanks

Jacob Eggers · Accepted Answer · 2011-06-24 00:42:31Z

2

I believe you want LIKE

ea.title LIKE '%tele%'

answered Jun 24, 2011 at 0:42

Jacob Eggers

9,3282 gold badges27 silver badges43 bronze badges

Collectives™ on Stack Overflow

Problem matching strings with MySQL

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related