database - mysql search LIKE not working for long phrase -
i have mysql table, type 'myisam', collation: 'latin1_swedish_ci'. inside it, have column named 'content'.
inside there, have row following content:
<p>the state have different advantage on other states, 1 of largest populations in nation blablablabla. </p>
my query in phpmyadmin , in php file:
select * `pages` `content` '%with 1 of largest populations%' order `pages`.`title` asc limit 0 , 30
0 rows returned.
the weird thing if edit query this:
select * `pages` `content` '%with 1 of largest%' order `pages`.`title` asc limit 0 , 30
then , 1 rows returned, , works.
is there setting might limit search query few words or few characters?
most there other whitespace character(s), otherwise, query seems fine.
try largest populations
should return 0 recs.
so replace, characters column before, searching.
Comments
Post a Comment