Hi all,

What would the query be where I select from a table where the first letter of the data in a field starts with a certain letter? For instance J.
Or would I just have to select all and then filter through in php?

Thanks,
Jason

select foo from bar where left(qux,1) = 'j'

never a need to filter with php. the only time you would probably need to use php would be for displaying your data in other ways than you can pull it out of the database.

You won by a minute here, happy? <lol>

Thanks for the replys

So in your examples, in the (), the first word (foo and qux), what do those reference? The field?
Also, is this case-sensitive?

Thanks,
Jason

foo is the canonical example of a metasyntactic variable

no, the sql is not case-sensitive

Isn't it easier just to say... SELECT foo FROM bar WHERE variable = 'J%'? Or am I missing something obvious here?

well, canman, you could, except that you would want to change it from

... WHERE variable = 'J%'

to

... WHERE variable LIKE 'J%'

Aye, I shall use that one, I never thought of that.

Thanks all
Jason