MySQL ~ ignore case

$xxx = strtolower('Bitty');

$sql = "SELECT xxxxxxxxxxxxxx FROM users WHERE lower(firstname) LIKE '%".$xxx."%'";

reference
http://bytes.com/topic/mysql/answers/689805-ignore-case-when-performing-search-mysql

沒有留言:

發佈留言