%% function does not work

[genzedu777]

Hi,

 

I would like to pull out data in my database based on 2 factors, 

 

1st

//Preferred level MUST be LOWER PRIMARY

Prefered_Level = 'lower primary'

 

2nd

//Preferred Subject has to be English, it doesn't matter if it has combination of different subjects, but English is a must, hence I have added this code.

Prefered_Subject ='%english%'

 

SELECT * FROM `tutor_prefered_subject` WHERE Prefered_Level ='lower primary' && Prefered_Subject ='%english%'

 

However it does not work, when I execute the command, it filters out 0 record

 

I have attached an image of the details in my database.

 

Anyone could give an advice?

 

[attachment deleted by admin]

[bh]

Hi,

 

use LIKE

SELECT * FROM `tutor_prefered_subject` WHERE Prefered_Level ='lower primary' && Prefered_Subject LIKE '%english%'

 

[genzedu777]

Thanks!!