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.

you can find here


Comments

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

Enable autocomplete or intellisense in Atom editor for PHP -