selecting from mysql where text = 'some_text' help pls

[UnknownPlayer]

How can i use

$query = "SELECT * FROM klanovi WHERE naziv = '{$trazi}' OR tag =  '{$trazi}'";

but i need to search from base where that $trazi is contained in naziv or tag, i mean like wildacards?

And how can i search that text but no matter of lowercase or uppercase ?

[requinix]

Use LIKE. It'll probably be case-insensitive for you.

"...WHERE naziv LIKE '%{$trazi}%' OR tag LIKE '%{$trazi}%'"

[wigpip]

$trazi = strtolower($trazi); 
$trazi = preg_replace('/\s+/', '|', $trazi);

 

then

 

lower(naziv) REGEXP '$trazi'

 

these are a few pointers as to the functions you will need to use, REGEXP is more forgiving and the preg_replace with OR lets it seach within

 

www.wigpip.com.au