Friday, November 26, 2010
How to make a selection based on the beginning value
An SQL command that selects the field’s values that start with a specific string.
SELECT * FROM `your_table_here` WHERE field_table REGEXP '^string_here';
The symbol
^
is telling MySQL to look at the beginning of the value.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment