[mythtv-users] Mythweb and keyword recording.

[Robert Longbottom]

On 24 May 2011, at 05:39 PM, Jan Johansson <j2 at mupp.net> wrote:

>> Sure, from the link bar along the top, click on "Custom" just after Recording Schedules.  Change the Search Type to Keyword Search (or use Power Search for even more flexibility).
> 
> 
> Ok, on a related note... the following SQL works nicely in mysql (0 rows returned)
> 
> select * from program where (program.title like '%U2%' or program.description like '%u2%') and program.category != "sports"
> 
> But when I plug 
> 
> where (program.title like '%U2%' or program.description like '%u2%') and program.category != "sports"
> 
> It still schedules programs like below... what am I missing now?

I'd try replacing the double quotes around "sport" with single quotes like you have around 'u2'.  

Assuming that's actually how it looks in the query and not and artefact of pasting into this email. 

Apart from that it looks ok to me. 

Robert. 

>