Hello i have a problem with search from mysql

i searched "caak" but result so many words get it. Then i reduce word number to $textw = substr($text,0,300); and then search again there is show 300 words fine. but my searched word "caak" wasn't show, only first words of sentence shown.

how i fix it?

what does your query look like?

 

You can use a wildcard like query with a limit. such as...

 

SELECT * FROM

something

WHERE keyword LIKE '%caak%'

LIMIT 5;