How to make a selection based on the beginning value
Posted on August 30, 2008, Filled under PHP,
Bookmark it
Thanks for visiting our website! We regularly publish posts like this one. If you are interested in receiving the latest updates as soon as they are posted, please consider subscribing to the RSS feed or to our e-mail newsletter.
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.
Do you wish to receive the latest updates as soon as they are posted? Get our RSS Feed or Subscribe to the Newsletter!
- August 30, 2008
- article by Gabriel C.
- Leave a reply!
Sponsors
Related Posts
-
How to make a selection based on the ending valueat August 30, 2008
-
How to make an alphabetical searchat August 30, 2008
-
Checking the beginning of a string (prefix)at August 30, 2008 with 1 comment
-
Create, Customize and Send Newsletters: MeeNewsat August 3, 2009 with 1 comment
