Quick PHP/ MySQL question

Posted: Sun Jan 09, 2005 12:26 am

Greets:

I'm trying to set up a sql query with a WHERE command that looks at the first letter of a field.

For example:

...WHERE (whatever the command is) starts 'A'...

or something like that.

Any suggestions?

Thanks,
-drmike

Subject Matter Expert Joined: Feb 23, 2004 Posts: 358

WHERE this_field LIKE 'a%'

should do the job...

% is the wildcard character in MySQL

Posted: Sun Jan 09, 2005 12:38 am

Thank you.

Been searching on the net for three hours now. *grumble*

-drmike

Posted: Sun Jan 09, 2005 1:05 am

drmike wrote:

Thank you.

Been searching on the net for three hours now. *grumble*

-drmike

Been there, done that Wink

You're very welcome...

PHrEEk