Select where variables starts with x - Databases forum at WebmasterWorld - WebmasterWorld

Forum Moderators: open

Message Too Old, No Replies

Select where variables starts with x

s9901470

5:20 pm on Mar 3, 2006 (gmt 0)

10+ Year Member

I'd like to select all rows where a variable starts with the letter s. How can I do this?

e.g.

SELECT *
FROM `table`
WHERE username STARTS WITH 's'

Nutter

5:46 pm on Mar 3, 2006 (gmt 0)

10+ Year Member

SELECT * FROM table WHERE field LIKE 's%'