Exploring Various SQL RegEx Syntax Print E-mail
Spread the news
Delicious
Furl it!
Spurl
NewsVine
Reddit
YahooMyWeb
Technorati
Digg
User Rating: / 0
PoorBest 
Written by Robby Ivanovitch   
Thursday, 23 October 2008
This is part two of my quest to Incorporating Regex into ORM’s and Database Abstractions. My first steps to exploring the option to implement uniform regex support into my own database orm/abstraction is to compare the syntax of the more popular database systems. To do so I will build an sql query where possible to search the body of page contents for ‘bla bla bla..’ in a test database table. MySQL select * from pages where body REGEXP '(bla(\s)?)+' Postgres select * from pages where

 

 

Copyright © 2008. All rights reserved.




Discuss this article on the forums. (0 posts)


 
< Prev   Next >
Community
Popular Blogs
All Blogs
Community Forum
Main Menu
Home
Forum
Directory
Links
Search
Newsflash
InformixTechDay in Strasbourg (the Capital of Europe)
Read more...
 
Insider - November 2008
Read more...
 
Ads
Login Form





Lost Password?
No account yet? Register