SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: Whats wrong with my query?
-
Dec 27, 2004, 18:42 #1
- Join Date
- Aug 2003
- Location
- Southern California, United States
- Posts
- 1,616
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Whats wrong with my query?
Whats wrong with this?
SELECT * FROM listings WHERE title REGEXP \"^\$this->letter\" ORDER BY title ASC
$this->letter is the variableHave a good day.
-
Dec 27, 2004, 19:04 #2
- Join Date
- Aug 2000
- Location
- Houston, TX, USA
- Posts
- 6,455
- Mentioned
- 11 Post(s)
- Tagged
- 0 Thread(s)
Aren't REGEXPs supposed to be in single quotes?
ssegraves [at] gmail.com
On Image Use, Abuse, and Where We're Headed
stephan | XMLHttpRequest Basics
flickr | last.fm | Cogentas, LLC
-
Dec 27, 2004, 23:07 #3
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
where left(title,1) = '$this->letter'
Bookmarks