![](https://seccdn.libravatar.org/avatar/ed12bc54bc5b499307092e4c89135812.jpg?s=120&d=mm&r=g)
Hello Brevsville, on Saturday, June 10, 2000 at 02:12:02 +0000, you sat in front of your keyboard and wrote:
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:
select * 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
I'm not an SQL expert too but I think that should be typed like:
elect * from mytable where field1 like '%word%' or field2 like '%word%' and
field3 = number;
Hope this helps...
--
Jean-François Bocquet