Jump to content

searching problem in mysql


Jaswinder

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/282180-searching-problem-in-mysql/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.