SQL Statement Where Clause

[Anon]

How would I write a sql statement equal to this psuedo-code:
select firstname, lastname from users where firstcharacteroflastname='c'
Thanks.
Mike

[brandonschnell]

SELECT firstname, lastname FROM users WHERE lastname LIKE 'c%'

[Anon]

Thanks, I read a little deeper into the manual and found I could do this
select * from users where lastname regexp "^c"
I have worked a lot with regexp also, so I used that. Thanks!
Mike

[[deleted]]

Just a note: regexp is not standard in SQL, so if you later decide to use a different type of database, you're F'ed.