searching problem in mysql

[Jaswinder]

hello friends..

i have one issue in searching..

 

my table structure is this

 

column name     type

id                       int

jokeby                varchar

joketitle              varchar

joke                    longtext

 

when i run a sql command in my phpmyadmin

 

select * from jokes where jokeby or joketitle like '%anonymous%'   - it does not show result

 

but when i change the order of columns like this

 

 

select * from jokes where joketitle or jokeby like '%anonymous%'   - it shows the result..

 

whats the mess ?? is there any particular order for this ??

 

i have 1 entry in the table with jokeby anonymous.

[Barand]

Correct syntax is

select * from jokes where jokeby like '%anonymous%' or joketitle like '%anonymous%'

[vinny42]

OR and AND always come between two expressions that give a boolean result, so "WHERE jokeby OR joketitle LIKE '%foo%'" tries to find records were jokeby equals TRUE, or joketitle contains 'foo'.

 

SQL looks like English but it's not quite English ;-)

[Jaswinder]

thanks for such a knowledgeable reply