php首字母搜索

Question

I have a search section in my web page. I used the following code to search the board member names.

$select_board="SELECT * FROM `tbl_boardmembers` WHERE `varBoardmembername` LIKE '%$find%'";

I need to change my code to search by using just the first letter. I tried this code

$select_board="SELECT * FROM `tbl_boardmembers` WHERE `varBoardmembername` LIKE '" . $letter . "%'";

But it doesn't works. How can i do that?

Answer 1

This is "Search by first letter of $find"

var $letter = substr( $find, 0, 1 );

$select_board="SELECT * FROM `tbl_boardmembers` WHERE `varBoardmembername` LIKE '" . $letter . "%'";