<html><body bgcolor="#FFFFFF"><div><br><br>On 21 Mar 2011, at 08:39 AM, Wayne Thomas <<a href="mailto:waynethomas69@gmail.com">waynethomas69@gmail.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><div class="gmail_quote">On Mon, Mar 21, 2011 at 8:04 AM, Nick Rout <span dir="ltr"><<a href="mailto:nick.rout@gmail.com"><a href="mailto:nick.rout@gmail.com">nick.rout@gmail.com</a></a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div></div><div class="h5">On Mon, Mar 21, 2011 at 7:19 PM, David Whyte <<a href="mailto:david.whyte@gmail.com"><a href="mailto:david.whyte@gmail.com">david.whyte@gmail.com</a></a>> wrote:<br>
> On Mon, Mar 21, 2011 at 4:07 PM, Wayne Thomas <<a href="mailto:waynethomas69@gmail.com"><a href="mailto:waynethomas69@gmail.com">waynethomas69@gmail.com</a></a>> wrote:<br>
>> I use:<br>
>> (program.title LIKE '%formula 1%'<br>
>> OR program.title LIKE '%F1%'<br>
>> OR program.subtitle LIKE '%formula 1%'<br>
>> OR program.subtitle LIKE '%F1%'<br>
>> OR program.description LIKE '%formula 1%'<br>
>> OR program.description LIKE '%F1%')<br>
>> it does pick up the occasional program that isn't Formula 1 (due to<br>
>> mentioning F1 in the description) but thats on only 3 or 4 a year and can<br>
>> easily be ignored (although they can be worth a watch too if you are F1<br>
>> crazy).<br>
><br>
> Brilliant. Thanks heaps!<br>
<br>
</div></div>Actually you might need to include some variations with one instead of<br>
1 (unless mysql's 'like' syntax is that clever)<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org"><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a></a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank"><a href="http://www.mythtv.org/mailman/listinfo/mythtv-users">http://www.mythtv.org/mailman/listinfo/mythtv-users</a></a><br>
</blockquote></div><br><div><span class="Apple-style-span" style="border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px; ">Not sure how clever the 'like' is but:</span></div><div><span class="Apple-style-span" style="border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px; "><br>
</span></div><div><span class="Apple-style-span" style="border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px; ">(program.title LIKE '%formula 1%'<br>
OR program.title LIKE '%F1%'</span></div><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">OR program.title LIKE '%formula one%'</span></font><br>
<font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">OR program.subtitle LIKE '%formula 1%'</span></font><br><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">OR program.subtitle LIKE '%F1%'</span></font></div>
<div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">OR program.subtitle LIKE '%formula one%'<br>
OR program.description LIKE '%formula 1%'</span></font><br><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">OR program.description LIKE '%F1%'</span></font></div>
<meta http-equiv="content-type" content="text/html; charset=utf-8"><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">OR program.description LIKE '%formula one%')</span></font></div>
<div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><br></span></font></div><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">would capture everything. I don't use it since I have never seen the word used rather than the number.</span></font></div></div></blockquote><br><div>LIKE isn't "clever" at all. The % symbol is a wildcard, equivalent to * when using say, ls *</div><div><br></div><div>Also mysql is case sensitive (I think) so it might be worth converting everything to upper case. I can't remember the mysql command for this, but it's probably something like TO_UPPER. So you'd want something along the lines of:</div><div><br></div><div>(TO_UPPER(program.title) LIKE '%F1%')</div><div><br></div><div>I must check what I've got later. </div><div><br></div><div>Robert. </div></body></html>