[ZNOTE] query with wildcard LIKE %...%

[raf]

I'm trying to get results in znote aac, with operator LIKE %...%, but it doesn't seem to work.

$data = mysql_select_single("SELECT * FROM `players` WHERE `name` LIKE '%$playername%' ");

I know that ZnoteAAC uses mysqli, but i have no clue how to make it work within mysql_select_single function.

 

[Codex NG]

$data = mysql_select_single("SELECT * FROM `players` WHERE `name` LIKE '$playername%' ");

 

[forgee]

$data = mysql_select_single("SELECT * FROM `players` WHERE `name` LIKE '%$playername%';");

Works fine for me.

 

[raf]

Both not working for me. Maybe that's because im using AJAX to get that ? Altho, if i dont put % signs, and do it like WHERE `name`='$playername' it's working but only if i type full name.