| | |
|
|
|
PHP Cool Tricks Reference |
|---|
| message from David B on 17 Jul 2004 |
Display only rows where each word in a particular column begins with B.
Display only words that END in a particular letter.
Display only words that contain combinations of letters, such as "angor."
Display only the first three letters of each word.
Change everything to lower case.
Change the first letters of every word except "and" and "the" to upper case.
I found a good reference a couple weeks ago, but I seem to have lost the
link.
Thanks.
|
| Craig replied to David B on 19 Jul 2004 |
try this: http://www.devguru.com/home.asp
Craig
"David B" <david_blomstromDELETETHIS@yahoo.com> wrote in message
news:cdco1a$nl5$1@forums.macromedia.com...
|
| Michael Fesser replied to David B on 19 Jul 2004 |
.oO(David B)
Assuming you want to do this in your queries:
... WHERE yourField LIKE 'B%';
... WHERE yourField LIKE '%B';
... WHERE yourField LIKE '%angor.%';
Answered in my other reply.
I would do this in PHP, maybe something like
$text = strtr(ucwords($text), array('And ' => 'and ', 'The ' => 'the '));
HTH
Micha
|
|
Archived message: PHP Cool Tricks Reference (Macromedia Dreamweaver)
