Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- FEL10
- FEL20
- FEL30
- PRO05
- PRO07
- PRO08
- VAI12
- VAI13
- VAI14
- FEL*
- PRO*
- VAI*
- SELECT col1 FROM table1 WHERE col1 LIKE 'FEL%';
- SELECT col1 FROM table1 WHERE col1 REGEXP '(FEL|PRO|VAI).*'
- SELECT distinct left(col, 3) as category FROM `table1`
- select distinct left(combicode, 3)
- from mytable;
- select *
- from mytable
- where combicode like concat(@category, '%');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement