[mythtv-users] Mythweb and keyword recording.

[Jan Johansson]

>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?

+--------+---------------------+---------------------+----------------------------------------------+----------+-------------------------------+----------+---------------+---------+-------+-----------------+-----------------+--------+-----------+------+----------------+------------+-----------+-----------+-----------------+----------+-----------+-------------------------+-----------+----------+---------+---------------+-------+------+-----------+---------------+-----------+
| chanid | starttime           | endtime             | title                                        | subtitle | description                   | category | category_type | airdate | stars | previouslyshown | title_pronounce | stereo | subtitled | hdtv | closecaptioned | partnumber | parttotal | seriesid  | originalairdate | showtype | colorcode | syndicatedepisodenumber | programid | manualid | generic | listingsource | first | last | audioprop | subtitletypes | videoprop |
+--------+---------------------+---------------------+----------------------------------------------+----------+-------------------------------+----------+---------------+---------+-------+-----------------+-----------------+--------+-----------+------+----------------+------------+-----------+-----------+-----------------+----------+-----------+-------------------------+-----------+----------+---------+---------------+-------+------+-----------+---------------+-----------+
|   6006 | 2011-06-05 18:30:00 | 2011-06-05 20:15:00 | Fotboll: U23-turneringen i Toulon, Frankrike |          | Gruppspel: Italien - Colombia | sports   | sports        |    2011 |     0 |               0 |                 |      0 |         0 |    0 |              0 |          0 |         0 | 108164901 | NULL            |          |           |                         |           |        0 |       0 |             4 |     1 |    0 |           |               |           |
+--------+---------------------+---------------------+----------------------------------------------+----------+-------------------------------+----------+---------------+---------+-------+-----------------+-----------------+--------+-----------+------+----------------+------------+-----------+-----------+-----------------+----------+-----------+-------------------------+-----------+----------+---------+---------------+-------+------+-----------+---------------+-----------+
1 row in set (0,00 sec)

mysql>