开发者

Problem matching strings with MySQL

开发者 https://www.devze.com 2023-03-15 14:03 出处:网络
I am having trouble matching strings in MySQL. I have the following: SELECT ea.* FROM epf_application ea

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 e开发者_如何学Goad.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?


Change it to

ea.title LIKE '%tele%'


I believe you want LIKE

ea.title LIKE '%tele%'
0

精彩评论

暂无评论...
验证码 换一张
取 消