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