MySQL Forums
Forum List  »  Performance

char and text who fast in "select ...like" with my database??
Posted by: hoowa sun
Date: December 17, 2004 03:16AM

my table has two fields following:
word1 Char(255),
word2 text,

in word1 most records used full length( >= 240),in word2 most records used short <= 100( a little >= 1000).

if i do
select * from table where word1 like '%apple%'
select * from table where word2 like '%apple%'

which one is fast?

Options: ReplyQuote


Subject
Views
Written By
Posted
char and text who fast in "select ...like" with my database??
2234
December 17, 2004 03:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.