How to regex in a MySQL query

by

I think you can use REGEXP instead of LIKE

SELECT trecord FROM `tbl` WHERE (trecord REGEXP '^ALA[0-9]')

More Related Contents:

  1. Restore table structure from frm and ibd files
  2. How to convert all tables from MyISAM into InnoDB?
  3. How to enable INNODB in mysql
  4. “Unknown column in ‘field list'”, but column does exist
  5. INSERT INTO SELECT statement with more columns which is not in another table
  6. MySQL how to fill missing dates in range?
  7. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  8. 1052: Column ‘id’ in field list is ambiguous
  9. How to split the name string in mysql?
  10. Is there a REAL performance difference between INT and VARCHAR primary keys?
  11. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  12. Cumulative sum over a set of rows in mysql
  13. How to set a maximum execution time for a mysql query?
  14. MySql: MyISAM vs. Inno DB! [closed]
  15. SQL keys, MUL vs PRI vs UNI
  16. Add Auto-Increment ID to existing table?
  17. MySQL SELECT DISTINCT multiple columns
  18. How to copy a row and insert in same table with a autoincrement field in MySQL?
  19. Using group by on two fields and count in SQL
  20. Can MySQL convert a stored UTC time to local timezone?
  21. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  22. MySQL CONCAT returns NULL if any field contain NULL
  23. Does Order of Fields of Multi-Column Index in MySQL Matter
  24. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  25. How do I rename a MySQL database (change schema name)?
  26. MySQL Integer vs DateTime index
  27. How to format number with “.” as thousands separator and “,” as decimal separator?
  28. How to check if field is null or empty in MySQL?
  29. Should I always prefer MySQL InnoDB over MyISAM?
  30. mySQL regex in the where clause

Leave a Comment