Search feature

[ainoy31]

I have a search option on my webpage where users enter someone's first and last name and click in the search button.  If the record is found in the database, the record data will be displayed else return an error message.  Instead of typing the full first and last name such as Olivia True, I want to just enter the first three letters for the first and last name.  Should I use a wildcard character or what is the best way to handle this?  Much appreciation.

 

thx.

 

AM

[B34ST]

try the like function using % as a wildcard, alternatively to the % if u know how many extra letters there is than 3 u could use undscore (each underscore represents another letter so if i search for oli___ it would show olivia:

$sql = mysql_query("SELECT * FROM table_name WHERE columnname LIKE value%"); 

[ainoy31]

thanks dude.