Select fields starting with A, B, C etc

[James_P]

The basic code I have to select the records I require is

mysql_query('SELECT * FROM my_table WHERE field2 = "Associations" ORDER BY field1');

Can you please let me know how I modify this so that it only returns those records where field1 starts with the letter A, letter B, etc?

I suppose I just need some help with the way wildcards are used.

Thanks,

James

[Darryl]

You ask for records where field1 starts with A, but your SQL example is using field2, with field1 used for sorting. Which do you really mean?

In any case, wildcards only work with the LIKE operator. So to use your example, try this:

SELECT * FROM my_table WHERE field2 LIKE 'A%' ORDER BY field1

[James_P]

Darryl, thanks for your help. Even with my stupidity in copying the wrong code you managed to work out what I needed.

Is now working perfectly. Thanks.

James

[Darryl]

Great. Glad I could help.