KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I need to write a query using MySQL REGEXP that will find me rows that have a certain column begin with 11 or 12 or etc. I know I can use LIKE or LEFT(####,2) but would like to use the REGEXP option. My data is stored as 110001, 122122, 130013a and etc. Update 1 : To make it a bit clearer, I would like to express: SELECT * FROM table WHERE column LIKE '11%' or column LIKE '12%' or column LIKE '30%'" With a REGEXP .
Tags (comma-separated)
Save Edits
Cancel