[Tutor] Help with a SQL Statement

[Khalid Al-Ghamdi]

Hi, I found one typo in 'Workshop&' which should be 'Workshop%' but it
still gives results containing majors with 'Customer%' and 'Warehouse%' in
them...


On Sun, Nov 18, 2012 at 2:21 PM, Khalid Al-Ghamdi <emailkgnow at gmail.com>wrote:

> Hi All,
>
> The SQL statement below doesn't return anything.. and I don't know why...
> I've used the parans but still no luck. Any Suggestions?
>
>     cur.execute("""select badge, name, stage, tc, major, package, subject,
> course, sb_as from records where
>                    sb_as = 0 and (subject like 'Workshop&' or subject like
> 'Basic%' or subject like 'Introduction%') and
>                    (major not like 'Customer%' or major not like
> 'Warehouse%') order by tc""")
>
> Thanks
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20121118/3acbe749/attachment.html>