[Resolved] [Resolved] [Resolved] [Resolved] search only first letters...

[pablodelapena]

hey hey.

I have a style of database design where i have 2 colomns: 'username(varchar 150)' and 'startLetter(char 1)'. This allowss me to search either the entire username or merely the first letter depending on what a user wishes to see.

However, Im attempting to clean up my ways of design and coding and im sure there is a much simpler way of doign what i want to do (return all rows where the starting letter of the column 'username' == a for example).

Is there a way in which MySQL can do this? muchos thanyous =D

[pete_bisby]

$sql = "SELECT * FROM table WHERE SUBSTRING(textField,1,1)='$char'";

Where $char could be the user's input.

Please note that MySQL's SUBSTRING function searches it's first character at position 1, and not zero like PHP's substring() function.

[pablodelapena]

thats awesome, thanks

RESOLVED!