Mailinglist Archive: opensuse (2425 mails)

[admin@xxxxxxxxxxxxxxxxx (Brevsville Administrator)]

I am not very good at SQL I'm just a lowly java programmer. So I have no
ideas why this SQl statement is wrong:

elect * from mytable where field1 like %word% or field2 like %word% and
where field3 = number

if I leave the "and where field3 = 2 "  out the query works.

The column  is an int so that should work and indeed if I use "select *
from mytable where field3 = 2"  that works.... 

What is wrong with this (or me) ?

Thanx

Chris
I'm lazy.. I'd rather smile and be happy, than work my face muscles so hard
to frown... why not join me!!!


-- 
To unsubscribe send e-mail to suse-linux-e-unsubscribe@xxxxxxxx
For additional commands send e-mail to suse-linux-e-help@xxxxxxxx             
Also check the FAQ at http://www.suse.com/Support/Doku/FAQ/