if i have a table "USERS" and a filed "username" how could a display for example all users starting with "S" or "smi" for example?
could i just put WHERE username =S*
thanks.
search users by begining of their user name
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Code: Select all
<?php
$sql = "SELECT * FROM USERS WHERE username LIKE 'S%'";
?>